topic Re: Grouping Calculated Dimensions in QlikView

Grouping Calculated Dimensions

Wed, 07 Dec 2011 15:15:48 GMT

Hi. I have a calculated dimension called Average Spend. I have calculated the average spend per customer using the aggr function. The measure on the Y axis is No Of Customers. What I want to do is to group the Average Spend so that the first bar is 0-200, the second 201-400, the third 401-600 etc. I cannot see a way of doing this. Can anyone help

Re: Grouping Calculated Dimensions

Wed, 07 Dec 2011 17:12:27 GMT

You may just try as below:

if(aggr(sum(average_spend),Customer)<=200,'0-200',
          if(aggr(sum(average_spend),Customer)<=400,'201-400',
          if(aggr(sum(average_spend),Customer)<=600',401-600','>600')
)
)

Only problem is that this is practical only if number of groups is less number. If you want one such grouping propably you can do this at script level. But generally the groups will be a fixed number

Regards,

Kiran.

Grouping Calculated Dimensions

Wed, 07 Dec 2011 18:27:10 GMT

Many thanks Kiran - this worked.