topic Re: Calculated Dimension (Bucket Analysis) in QlikView

Calculated Dimension (Bucket Analysis)

mjamesking — Thu, 20 Jul 2017 18:53:13 GMT

Hi,

Struggling a little bit with some bucket analysis using a calculated dimesnion. Simple example qvw attached.

Basically I can define the bucket as a calculated dimesnion. The chart seems to correctly count the number of IDs that fall in each bucket for each year, but when I try to calculate the TOTAL Ids for the year (in order to create a 100% bar chart) it seems to ignore TOTAL <Year> part of the formula and give me the same result as the simple COUNT. Where am I going wrong?

Hope someone can help.

Thanks

Matt

Re: Calculated Dimension (Bucket Analysis)

sunny_talwar — Thu, 20 Jul 2017 18:58:27 GMT

Try this

=Aggr(NODISTINCT Count(DISTINCT ID), Year)

Re: Calculated Dimension (Bucket Analysis)

mjamesking — Thu, 20 Jul 2017 19:06:05 GMT

That works, thanks!

Can you explain the difference between the two methods and why one works but not the other?

Thanks

Matt

Re: Calculated Dimension (Bucket Analysis)

sunny_talwar — Thu, 20 Jul 2017 19:11:56 GMT

Not sure why the TOTAL isn't working (I would have thought that it would work and I would have suggested you to use it), but to see the what they do, check here:

Qlik Tips: No nodistinct