Re: Restrict Dimension with '0' value in qliksense
To translate it in human words:
a dimension is a list of values; and we want to show only values where there is sum of YourMeasure >0
if YourMeasure =0 in the dimension value,do not show it (null()) else, show the values where there is a measure:
to break it:
this is the condtion!
Note: since, by default, Qlik won't show null() values in a filter box, all of these newly created null() values won't be shown in our master dimension.
But till now, we want to create a dimension; and we're using a measure (sum(YourMeasure) without aggregating it to the dimension it self; in fact, we want to see this condition on the YourDimension level.