Toggle in Qlik Sense

[mhmmd_srf]

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

[undergrinder]

Hi Mohammad,

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

G.

[Anonymous]

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

[#4]

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.