Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
If I have a list like this. 2 Columns:
Place Name
1 First, Person
2 Second, Person
3 Third, Person
and i want to use a variable, let's call it vSearchBox, to decide which rows to display in a table.
If I put first in the input box I only want to see 1 row of data.
If I put ird in the input box I only want to see 1 row of data.
If I put erson in the input box I want to see 3 rows of data.
If the input box is empty I want to see all 3 rows of data.
What would my syntax be?
Should I create a set expression? I've tried using WildMatch, Like, Only and various if statements to get what I want but I'm stumped and can't find a relevant example in the forums.
I suspect this is in Qlik view since you mentioned Input box.
Anyway, Something like this?
When you type In Input Box and enter?
QVW attached for ref.
Expression Used for Place: =If(WildMatch(Place, '*' & '$(Variable1)' & '*'), Place)
I suspect this is in Qlik view since you mentioned Input box.
Anyway, Something like this?
When you type In Input Box and enter?
QVW attached for ref.
Expression Used for Place: =If(WildMatch(Place, '*' & '$(Variable1)' & '*'), Place)
It is in Qlik Sense. I should have been more specific. It is a Variable Input Box from the Dashboard bundle.
Also, Place is an integer and all 3 people have the same last name.
I did not try using the & for the comparison string. That seems to do the trick.
Many thanks.