Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Total qualifier with calculated dimension

Hi ,

I have a problem with a bar chart with a dimension and a calculated dimension as a second dimension. The 1st dimension is a group of 6 different fields and the calculated dimension shows how many objects that are below or above a certain threshold. The chart is working but  I am trying to show the percentage for each field in the first dimension that has above/below (compared to it self). I have tried to use count(distinct VIN)/count(Total distinct VIN) but it is not working. In my attached example I have 2 charts with calculated dimension and 2 charts with expression instead.  So basically the calculated dimension chart should look the same as the regular expression chart.

Any input is much appreciated!

Br

Patrik

1 Reply
Not applicable
Author

This expression seems to work for some of the fields :RangeSum(ABOVE(aggr(count( DISTINCT VIN),IUPRGroup),0,2))

but not for all