Calculated Dimension to Create Groups

Mon, 12 Mar 2012 22:23:24 GMT

I am new to Qlikbook and I am having difficulty returning the correct sum of the quantity sold by customer. I am trying to break the quantity purchased by customer into brackets (<12, 12-19, 20-29, etc) by Year.

Dimensions

I am using the following Dimensions - Calculated Dimension, Year

Here is the calculated dimension expression that I created. (QVOF = Quantity)

=If((QVOF<12),'<12',If((QVOF>=12 and QVOF<20),'12-19',If((QVOF>=20 and QVOF<30),'20-29',If((QVOF>=30 and QVOF<40),'30-39',If((QVOF>=40 and QVOF<80),'40-79','80+')))))

Expressions

sum(QVOF)

I am then graphing the data by Year

Do I need to use the AGGR function?

Re: Calculated Dimension to Create Groups

swuehl — Mon, 12 Mar 2012 23:35:58 GMT

Not sure if I fully understood what you want to achieve, but your calculated dimension and your expression look ok to me at first glance - what problems do you have in detail?

Could you give an example of your result and what you expect?

topic Calculated Dimension to Create Groups in QlikView

Calculated Dimension to Create Groups

Re: Calculated Dimension to Create Groups