topic Re: Toggle in Qlik Sense in App Development

Toggle in Qlik Sense

mhmmd_srf — Wed, 15 Jun 2016 13:45:20 GMT

Hi Friends,

Hope you are doing good.

I have a requirement of Toggle button.

We need to put a toggle button in Dashboard. There would be two text Cumulative and Non Cumulative. Depending on the selection it will show either Cumulative chart or Non Cumulative chart. The calculation is only difference between two Chart.

I could do this in Qlikview using variable however in Qlik sense I am not able to do.

Could you please help me on this.

Thanks in advance for your time...

Regards,

Sarif

Re: Toggle in Qlik Sense

undergrinder — Thu, 16 Jun 2016 07:40:09 GMT

Hi Mohammad,

you can find extensions at Qlik Branch, that do the work.

Re: Toggle in Qlik Sense

Anonymous — Thu, 16 Jun 2016 19:43:28 GMT

in a future version you will be able to create alternative dimensions

but in the mean time you can create a makeshift cyclic group with the below

Create an inline table in the script

DimensionSelector:
Load * inline
[
Selector, Name
'a','NameA'
'b','NameB'
'c','NameC'
'd','NameD'
'e','NameE'
'f','NameF'
'g','NameG'
];

This will create two new fields 'Selector' and 'Name'

Create a master item dimension with the fields being the dimension you want the user to be able to select

if(Selector='a',[Field A],
if(Selector='b',[Field B],
if(Selector='c',[Field C],
if(Selector='d',[Field D],
if(Selector='e',[Field E],
if(Selector='f',[Field F],
if(Selector='g',[Field G])))))))

Use that master item dimension as a dimension in your chart and create a filter pane with the field 'Name' from the inline table.

Selecting a name in the filter pane will make the chart change, as there is no way to limit the selection to just one it is also wise to add a calculation condition on the chart.Calulation condition can be found under Add-ons > Data handling, I use getselectedcount(Name)=1

Re: Toggle in Qlik Sense

Fri, 17 Jun 2016 02:59:50 GMT

Hi,

Whether you can download Checkbox Master from Qlik branch that allows you to turn on/off variable.

Or you can create a dummy table with 2 values, Cummulative & NonCummulative. Then in your chart expression, depends on what you select: If(GetFieldSelections(Filter)='Cummulative', <exp1>, <exp2>)

The negative thing here is you can't switch your selection, so you have to unselect & select new one.

But if you use the extension, it'll handle it nicely.