Missing 'Show Dimension/Measure If' in Combo Chart

[poklegoguy]

Hi, I am working on Qlik Sense Desktop and I am trying to develop a combo chart where the chart will show a certain dimension(s) or measure(s) based on the selection(s) of the Dimension and Measure filter panes. The user should be able to choose one or more dimensions and measures to display in the combo chart, the pivot table or bar chart have this show dimension/measure if feature and this serve my purpose well but not for the combo chart. If the user is limited to only one selection for both the dimension and measure filter panes then it is doable but not for multiple selections. Is there any workaround for this missing-feature of combo chart? Looked up this problem but seems like no one has asked about this. Vizlib has this feature in its combo chart but i'm not ready to commit to a paid subscription yet. It's frustrating seeing Qlikview has almost all the features available across all the different charts while Qliksense doesn't.

[Rohan]

Hi @poklegoguy ,

I can think of a workaround, Use a Container & put 2 Combo Charts in to it. 1 Combo Chart with single dimension setting & other with 2 dimension setting. & then do the hide & show using the Container's properties.

Also For Combo chart / Bar charts, the max you can have 2 dimensions so, you won't have to worry about more than 2 dimensions.

Regards,

Rohan.

[poklegoguy]

Hi @Rohan, thanks for replying. The problem is that I have 2 filter panes with list of dimension like 'Outlet', 'Region', 'State' and list of measures like 'Actual Sales', 'Budget Sales', 'Profit' etc and I want the chart to display the dimension(s) and measure(s) user selected on the 2 filter panes. The user can select more than 1 dimension and measure to display in the combo chart, without the 'show if' feature, how do I hide the dimension(s) and measure(s) that is not selected?

[Rohan]

Hi @poklegoguy ,

Check this video on ADHOC reporting : 

https://www.youtube.com/watch?v=OMSlWDPvfy8

You can expand this idea to charts too.

Regards,

Rohan.

[poklegoguy]

Hi @Rohan, thanks for taking the time to reply. The steps shown in the video is exactly how I created my adhoc pivot table, now just that I need to do the same with combo chart. The 'show if' feature seems very crucial for this and we don't have that feature in combo chart.

[Anil_Babu_Samineni]

As a workaround can't you use Alternate dimensions? With this, the user can select inside the combo chart how they want.

[Rohan]

Hi @poklegoguy ,

That's what I am saying. instead of applying hide & show in at dimension level in the chart, Put 2 combo charts in a container & leverage the Hide & show property of the Container.

Subfield(Concat(distinct Dimension,'|'),'|',1) in 1st Dimension & Subfield(Concat(distinct Dimension,'|'),'|',2) in 2nd Dimension, if your concern is how do i add dimensions to the chart then try the above. Expand it to the measures part too.

Regards,

Rohan.

[poklegoguy]

Hi @Anil_Babu_Samineni, isn't that the user can only select one alternate dimension at a time? I need the chart to display multiple dimensions if the user selected multiple options from the filter pane. 

[Anil_Babu_Samineni]

Like i said, that is limitation with chart, please read more: Combo chart | Qlik Sense on Windows Help

[Rohan]

Hi @poklegoguy ,

Extreme apologies, I was thinking of a bar graph instead of a combo chart. I was just wondering if you can switch to a bar graph instead, where you would have the option to show 2 dimensions with 1 measure or 1 dimension with multiple measures..

Regards,

Rohan.