Does any one know when Table in QS able to have alternative in dimension ?

paulyeo11 — Wed, 13 Apr 2016 03:10:27 GMT

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

Re: Does any one know when Table in QS able to have alternative in dimension ?

Anonymous — Thu, 14 Apr 2016 19:50:02 GMT

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?

topic Re: Does any one know when Table in QS able to have alternative in dimension ? in App Development

Does any one know when Table in QS able to have alternative in dimension ?

Re: Does any one know when Table in QS able to have alternative in dimension ?