Hello
I am trying to filtering my listbox
So far i cant see all the schools by idnr "1003" and filtering out courses starting och E or S
But not combined , Filter(klass ; Skola =ddSkola.SelectedText.Value; Program = Filter( tblProgram; StartsWith(Program; "E") Or StartsWith(Program; "S"))).Program
This is how i think it dosent work out maybee its not possible
Works Code Filter(tblProgram;Kostnadsställe="1003").Skola
Works Code Filter( tblProgram; StartsWith(Program; "E") Or StartsWith(Program; "S")).Program
Solved! Go to Solution.
Here's how I would combine your 2 working FILTER functions.
Filter(
klass;
Skola = ddSkola.SelectedText.Value;
StartsWith(Program; "E") Or StartsWith(Program; "S")
).Program
If Skola is a number it might be necessary to put this section of code inside the value function
Skola = Value(ddSkola.SelectedText.Value)
---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
Here's how I would combine your 2 working FILTER functions.
Filter(
klass;
Skola = ddSkola.SelectedText.Value;
StartsWith(Program; "E") Or StartsWith(Program; "S")
).Program
If Skola is a number it might be necessary to put this section of code inside the value function
Skola = Value(ddSkola.SelectedText.Value)
---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
User | Count |
---|---|
196 | |
124 | |
88 | |
48 | |
42 |
User | Count |
---|---|
280 | |
163 | |
138 | |
81 | |
76 |