Calculated Dimension (Bucket Analysis)

[mjamesking]

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

[sunny_talwar · Accepted solution]

Try this

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

[mjamesking]

That works, thanks!

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

Thanks

Matt

[sunny_talwar]

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