Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP 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