topic Re: Can we change the dimension of a bar chart with a parameter in qlik sense? in App Development

Can we change the dimension of a bar chart with a parameter in qlik sense?

Wed, 30 Mar 2016 19:54:57 GMT

This is the functionality similar to the parameter capability in tableau where there is a someone could select say customer, buyer, or territory and the colors of a bar chart would split by customer, buyer, or territory or whatever they selected. Is this possible in qlik sense?

Thank you ahead of time

Re: Can we change the dimension of a bar chart with a parameter in qlik sense?

Anonymous — Thu, 31 Mar 2016 00:38:11 GMT

I think what you are looking for is called 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.

Re: Can we change the dimension of a bar chart with a parameter in qlik sense?

Thu, 31 Mar 2016 01:27:07 GMT

Yes Bella this is what I was thinking about, I just couldn't remember the name.

Could you elaborate a little bit more on inline tables and buttons?

Thank you

Re: Can we change the dimension of a bar chart with a parameter in qlik sense?

Thu, 31 Mar 2016 07:02:23 GMT

You could use extensions: Makes Sense to go round in circles

Alternate States could also help (i remember seeing links about it as it is new to Qlik Sense v2.2 - can't find them right now!)

It would also be possible with a Variable - although a little more complex:

In your Load Script create a separate table (make sure the field name does not match any existing field names - so there is no join) which lists the Dimension you want to choose from, with an incrementing number relating to it

Create a variable, which is: =IF(MAX([YourDimensionListNumber])=1, [FirstDimension],etc.

Then setup your bar chart to have the variable as a Dimension and add a Filter, with [YourDimensionListName] in it. Then when you choose an option from this list, it will show that dimension. It you select more than one option, it will choose the last one.

Re: Can we change the dimension of a bar chart with a parameter in qlik sense?

Thu, 31 Mar 2016 07:08:08 GMT

knew it was somewhere: Qlik Sense Alternate States - The Full Set - YouTube

Re: Can we change the dimension of a bar chart with a parameter in qlik sense?

brunobertels — Thu, 31 Mar 2016 07:42:34 GMT

See app attached it gives a simple example of cyclic group using variable and the way to change colors of bar chart depending of the dimension.

Regards

Bruno

Re: Can we change the dimension of a bar chart with a parameter in qlik sense?

saniyask — Thu, 31 Mar 2016 09:22:23 GMT

Hi Bruno,

Thanks for sharing an alternative for cyclic group, it was very useful.

Regards,

Saniya Shaikh.

Re: Can we change the dimension of a bar chart with a parameter in qlik sense?

brunobertels — Thu, 31 Mar 2016 10:11:20 GMT

you're welcome

Re: Can we change the dimension of a bar chart with a parameter in qlik sense?

Anonymous — Thu, 31 Mar 2016 18:29:09 GMT

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

Re: Can we change the dimension of a bar chart with a parameter in qlik sense?

Wed, 11 May 2016 15:06:20 GMT

Hi,

From version 2.2.4 cycles are embedded within Sense, without using extensions. Just add 'Alternative dimensions' as shown below the dimension you already use in a visualization. From the menu of each visualization, the end-users can choose between the dimension and alternative dimension. This way you can create very powerful combinations by using drill-down master items and 'cycles'/alternative dimensions. Have a look at What's New in Qlik Sense 2.2 - Presentation - YouTube.

Re: Can we change the dimension of a bar chart with a parameter in qlik sense?

Anonymous — Wed, 11 May 2016 19:50:04 GMT

Good to know, thanks

Re: Can we change the dimension of a bar chart with a parameter in qlik sense?

ali_hijazi — Mon, 23 May 2016 09:39:56 GMT

can you please provide me with the extension zip file?

Re: Can we change the dimension of a bar chart with a parameter in qlik sense?

brunobertels — Mon, 23 May 2016 10:01:45 GMT

the extension is available on qlik branch site

http://branch.qlik.com/#!/project/56728f52d1e497241ae697f8