topic Re: Total qualifier with calculated dimension in QlikView https://community.qlik.com/t5/QlikView/Total-qualifier-with-calculated-dimension/m-p/1204648#M518407 <HTML><HEAD></HEAD><BODY><P>This expression seems to work for some of the fields :RangeSum(ABOVE(aggr(count( DISTINCT VIN),IUPRGroup),0,2))</P><P></P><P>but not for all</P></BODY></HTML> Wed, 02 Nov 2016 13:41:26 GMT 2016-11-02T13:41:26Z Total qualifier with calculated dimension https://community.qlik.com/t5/QlikView/Total-qualifier-with-calculated-dimension/m-p/1204647#M518406 <HTML><HEAD></HEAD><BODY><P> Hi ,</P><P></P><P>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&nbsp; 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.&nbsp; So basically the calculated dimension chart should look the same as the regular expression chart.</P><P></P><P>Any input is much appreciated!</P><P></P><P>Br</P><P>Patrik</P></BODY></HTML> Wed, 02 Nov 2016 10:36:20 GMT https://community.qlik.com/t5/QlikView/Total-qualifier-with-calculated-dimension/m-p/1204647#M518406 2016-11-02T10:36:20Z Re: Total qualifier with calculated dimension https://community.qlik.com/t5/QlikView/Total-qualifier-with-calculated-dimension/m-p/1204648#M518407 <HTML><HEAD></HEAD><BODY><P>This expression seems to work for some of the fields :RangeSum(ABOVE(aggr(count( DISTINCT VIN),IUPRGroup),0,2))</P><P></P><P>but not for all</P></BODY></HTML> Wed, 02 Nov 2016 13:41:26 GMT https://community.qlik.com/t5/QlikView/Total-qualifier-with-calculated-dimension/m-p/1204648#M518407 2016-11-02T13:41:26Z