Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

mjamesking
Contributor

Calculated Dimension (Bucket Analysis)

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

1 Solution

Accepted Solutions

Re: Calculated Dimension (Bucket Analysis)

Try this

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

View solution in original post

3 Replies

Re: Calculated Dimension (Bucket Analysis)

Try this

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

View solution in original post

mjamesking
Contributor

Re: Calculated Dimension (Bucket Analysis)

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)

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