topic Re: chart with calculated dimension in QlikView

chart with calculated dimension

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Dear all,

I have a chart with calculated dimension which i want to show as pareto however the cumulative is not summing correctly. i have tried to investigate but cant find a solution.

In the dimension i have this expression

=DUAL(

Replace(Class([Time Waiting (hrs)], 3), '<= x <', '-')&' hrs'

,Class([Time Waiting (hrs)], 3))

and in the expression for bars i have this

Count({<PerformedOp = {1}, PastDays = {1}, SessionType = {'Evening'}, Department -={'XXXX'}, CaseType = {'Emergency'}>}DISTINCT PAT_ID)

the cumulative which is not showing correct has this

RangeSum( Above(Count({<PerformedOp = {1}, PastDays = {1}, SessionType = {'Evening'}, Department -={'XXXX}, CaseType = {'Emergency'}>}CUST_ID), 0,RowNo()))

COUNT({<PerformedOp = {1}, PastDays = {1}, SessionType = {'Evening'}, Department -={'XXXX}, CaseType = {'Emergency'}>} TOTAL CUST_ID)

Re: chart with calculated dimension

sunny_talwar — Mon, 03 Oct 2016 16:47:17 GMT

Not sure what exactly is the issue here? is it showing 131 instead of 136 is the issue?

Re: chart with calculated dimension

Anonymous — Tue, 04 Oct 2016 07:33:22 GMT

yes that is the issue the is not matching so when i i sho the cumulative percentage it shows 105%

Re: chart with calculated dimension

Anonymous — Tue, 04 Oct 2016 07:51:45 GMT

hi, it seems as if the total is removing duplicates, i have checked and noticed the 5 missing values have duplicates so it is counting and distinct only

Re: chart with calculated dimension

sunny_talwar — Tue, 04 Oct 2016 15:46:38 GMT

Would you be able to share a sample to check this out?