topic Re: Toggle switch in QlikView

Toggle switch

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Toggle switch

effinty2112 — Mon, 21 Aug 2017 19:36:48 GMT

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

Re: Toggle switch

Mon, 21 Aug 2017 20:05:34 GMT

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

Re: Toggle switch

MarcoWedel — Mon, 21 Aug 2017 21:04:09 GMT

Hi,

one solution might be also:

hope this helps

regards

Marco

Re: Toggle switch

Tue, 22 Aug 2017 14:24:02 GMT

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

Re: Toggle switch

MarcoWedel — Tue, 22 Aug 2017 17:33:40 GMT

you're welcome

glad you liked it.

Marco