Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
Does any one have above info ?
As chart recently already add alternative , which help a lot. and i hope in future table have add this feature , it will be able to save me a lot duplicate sheet.
Paul
Hi Paul
Do you mean you want to change the parameter/dimension of the table? if so you may be looking for a cyclic group, these are a built in feature of QlikView but not Qlik Sense. It is possible to create the effect with inline tables and buttons but it is clunky and can slow down performance.
This is how I have done it before
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
There is a longer discussion on it here - Can we change the dimension of a bar chart with a parameter in qlik sense?