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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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