topic Re: Customize Class Function in QlikView

Customize Class Function

Thu, 15 Oct 2015 08:55:02 GMT

Hi Guys

Two things:

Im currently using the class function and i get the result below:

Band	Sum
0 - 3	1 100
3 - 6	25 600
6 - 9	500
9 - 12	946
12 - 15	6 324
15 - 18	1 659
18 - 21	100

However my desired result would be the following:

Band	Sum
0 - 3	1 100
3 - 6	25 600
6 - 9	500
9 - 12	946
12 +	8 083

Is there a way to do this? Where you could set a max on the class like my example above of 12+, instead of 12 - 15, 15 -18 etc.

Second thing:

2. Is there a way to customize the Class?

For example:

0 - 3,

4 - 6,

7 - 9,

10 - 14,

15 - 19 etc ...

Re: Customize Class Function

rubenmarin — Thu, 15 Oct 2015 09:16:49 GMT

Hi Magen, for the first thing you can check first the '+12' and then use class, ie:

If(Band>12, '+12', class(...))

For the second, if you don't have a fixed step beteween values you should apply each condition using concatenated 'If':

If(Band<4, '0-3', //Better using Dual('0-3', 0) instead of the string '0-3', helps sorting values

If(Band<7, '4-6',

In your example you don't have fixed steps:

0 - 3, //4 values

4 - 6, // 3 values

7 - 9, // 3 values

10 - 14, // 5 values

Re: Customize Class Function

nagarjuna_kotha — Thu, 15 Oct 2015 09:24:41 GMT

Check this Sample app .it might help you.

Re: Customize Class Function

krishna20 — Thu, 15 Oct 2015 09:32:57 GMT

Hi,

Try this in your script below the SUM Field.

if(SUM >=0 and SUM <=3,Dual('0-3,0',1),

if(SUM >=4 and SUM <=6,Dual('4-6',2),

if(SUM >=7 and SUM <=9,Dual('7-9',3),

if(SUM >=10 and SUM <=14,Dual('10-14',4),

if(SUM >=15 and SUM <=19,Dual('15-19',5),

if(SUM >20,Dual('Above 20',6))))))))) as Band

Hope it helps.

Re: Customize Class Function

sunilkumarqv — Thu, 15 Oct 2015 10:15:18 GMT

Try this in script or expression

Text(If(TempBrand<12,Replace(Class(TempBrand,6),' <= x < ','-'),'+12')) as Brand

Expression

Text(If(TempBrand<12,Replace(Class(TempBrand,6),' <= x < ','-'),'+12'))