Toggle switch

[#1]

Hi Qlik Experts,
Today I was trying to select different field values on qlik using toggle. I have a field with two values Y and N. I want to have a action such that on click
click 1. It selects Y and Displays measured only

click 2. It selects N and displays non measured site
click 3. It selects N & Y , displays both included. and then continues to 1,2,3 so on

Thanks

[effinty2112]

Hi Naveen,

try these two actions and use the one you prefer, replace Filed with your fieldname:

=if(isnull(GetFieldSelections(Field)),'Y',Pick(Match(GetFieldSelections(Field),'Y','N'),'N',''))

=if(isnull(GetFieldSelections(Field)),'Y',Pick(Match(GetFieldSelections(Field),'Y','N'),'N','**'))

cheers

Andrew

[#3]

Hi Andrew,

Thank you for your response. I tried the expression you provided and for me it toggles between only N, N and Y combined. I would like it to select N on first click Y on second both on third and if clicked fourth time it selects N and then Y so on. Is that possible. I have tried what you suggested and attached it here.

Thanks

[MarcoWedel · Accepted solution]

Hi,

one solution might be also:

hope this helps

regards

Marco

[#5]

Thank you Marco, that worked exactly like how i wanted.

[MarcoWedel]

you're welcome

glad you liked it.

Marco