topic Re: calculated dimension in QlikView

calculated dimension

Wed, 03 Jun 2015 13:33:47 GMT

I have a calculated dimension of age and i want to represent as <15, 16-25, 26-35, 36-45, 46-55, 56-65, >66 on the X-axis..help me how to get it..

Re: calculated dimension

ecolomer — Wed, 03 Jun 2015 13:40:30 GMT

o bien utilizas IntervalMatch o lo haces a través de una variable o if encadenado

Re: calculated dimension

sunny_talwar — Wed, 03 Jun 2015 13:51:30 GMT

You can create this as your calculated dimension:

If(Age < 16, '<15',

If(Age < 26, '16-25',

If(Age < 36, '26-35',

If(Age < 46, '36-45',

If(Age < 56, '46-55',

If(Age < 66, '56-65', '>66'))))))

Re: calculated dimension

Wed, 03 Jun 2015 13:58:07 GMT

Thanks sunindia..but is there any other ways of doing this by using Aggr function or by using set analysis?

Re: calculated dimension

sunny_talwar — Wed, 03 Jun 2015 14:02:33 GMT

There is a class function you can use, but that usually gives equal intervals. Syntax is something like this:

=Class(Age, 10, '-')

Re: calculated dimension

maleksafa — Wed, 03 Jun 2015 14:12:17 GMT

use the class function to do that, and it takes as parameter the number of brackets that you want.

however i prefer that you do it from the script during the load and not from the chart, as it is not recommended to have calculated dimensions (for performance issues)