Create a master dimension of your current dimension used in your combo chart.
Use if statements to check for the condition you are looking for in your combo chart. Will need to use AGGR on your Dimension to bring back the right measures to check
Once done you can include this in your combo chart and un tick show null values which will remove the dimensions you want from your view.
Hope this helps.
Hi Andy, what you suggested is working but not very easy to manage, especially when creating a master drill-down dimensions library. In this scenario I'll have to consider all possible combinations of dimensions/measures.
After almost a year I still don't understand why Qlik doesn't implements a simple option in dimension limitation properties that enables users to choose on which measure the limitation must be evaluated (e.g. a combobox with all measure names as possible values, plus an "all measures" and "at least one measure" values).
For example, let's consider a chart with 3 measures, and set up a dimension "exact value" limitation greater than zero. This combobox will have this values:
- Limit on measure 1; (measure 1 must be greater than zero)
- Limit on measure 2; (measure 2 must be greater than zero)
- Limit on measure 3; (measure 3 must be greater than zero)
- Limit on all measures; (ALL measures must be greater than zero)
- Limit on measures sum; (at least one measure must be greater than zero)
Hi Paolo Mapelli,
Creating a calculated dimension may reduce the performance if you have lot of data, but it does work as Andy Weir has mentioned.
As an alternative you can also restrict it this way.
if( sum(measure) > 0, sum(measure)) - for all the measures which you would like to display in the combo chart.