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.

[poklegoguy]

Hi @Rohan, 

Thanks for taking the time to reply. Unfortunately, its a requirement by the stakeholder to need a combo chart, guess it was impossible to do so with the current Qlik Sense.

[poklegoguy]

Hi @Rohan, I used a method like =IF(SubStringCount(Concat(_MeasureSelection, '|'), 'A') = 0, null(), sum(Actual)) to force the measure to show as null if it is not selected, but the measure will still show as a gap in the combo chart even though it has null value or shown as '-', do you have any idea how do I remove the gap in the combo chart? I have tried uncheck the 'Include null values' in the Dimension section and also tried making the measure to have 0 as value and uncheck the 'Include zero values' in Data Handling section but non of those work. 

[Rohan]

Hi @poklegoguy ,

Try :

Sum([$(=Subfield(Concat(_MeasureSelection,'|'),'|',1))]) as your measure & then in data handling untick the include 0. Check this & let me know if it worked.

Regards,

Rohan.