Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guru's,
I have a country list box(filter) in Qlik sense app with values country1,country 2,........country10.
Requirement: if i click on Buttion 1 ,the listbox should show only values country 1,country2,country3
if i click on Button 2, the list box should show only values country4,country5,country6
if i click on Button 3, the list box should show only values country7,country8,country9,country10
if i click on Button 4,the list box should show all country field values i.e country1,2,3, country10.
After clicking the button the out put field values should be available for selections but not get selected .
Please help me to achieve this requirement.
Thanks in advance,
Jason
You can do this by using a flag.
in the script, you have to do different dimensions for the values.
If(country = country 1 or country 2 or country 3, country ,null() as "Button 1 Country",
If(country = country 4 or country 5 or country 6, country ,null() as "Button 2 Country", and so on.
Then in the variable input, you create a variable you can call it vButtonSelect.
Create a variable input and add the variable to it.
create a FilterPane and enter the dimension and write:
if $(vButtonSelect) = 1, "Button 1 Country"
if($(vButtonSelect) = 2, "Button 2 Country" ))
Now the filterPane will show different values based on the variabel.
You can do this by using a flag.
in the script, you have to do different dimensions for the values.
If(country = country 1 or country 2 or country 3, country ,null() as "Button 1 Country",
If(country = country 4 or country 5 or country 6, country ,null() as "Button 2 Country", and so on.
Then in the variable input, you create a variable you can call it vButtonSelect.
Create a variable input and add the variable to it.
create a FilterPane and enter the dimension and write:
if $(vButtonSelect) = 1, "Button 1 Country"
if($(vButtonSelect) = 2, "Button 2 Country" ))
Now the filterPane will show different values based on the variabel.