topic Re: Class Function in QlikView

Class Function

beck_bakytbek — Wed, 25 Nov 2020 16:16:04 GMT

Hi Folks,

i have a question:

i use Class-function to achieve the following result (please see attached screenshot),

my class-function does look like: DUAL(Replace(class(Differenz,30),'<= x <','-'),class(Differenz,30)), but i have got a following output:(see attached screenshot),

How can i achieve with class-function this expected output:

0 -30 Days

31 -90 Days

181 - 365 Days

more than 365 Days

thanks in advance

beck

Re: Class Function

Siva_Sankar — Wed, 19 Apr 2017 08:40:17 GMT

Beck,

I dont think that you can achieve using Class function, instead you use nested or embedded if() statements (if you need to use the calculated dimension), or use an INTERVALMATCH with a custom bucket table in the script. To create buckets. you can check here on how to create buckets here https://community.qlik.com/blogs/qlikviewdesignblog/2014/07/14/buckets

something like below..

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

if(Differenz >=31 and Differenz <=90,Dual('31-90',2),

if(Differenz >=91 and Differenz <=180,Dual('91-180',3),

if(Differenz >20,Dual('Above 20',6))))))) as Days_Bucket

Eg:

If( ShippedDate - RequiredDate <= -5, 'Too early',

If( ShippedDate - RequiredDate <= 0, 'Just in time',

If( ShippedDate - RequiredDate <= 5, 'Small delay',

'Large delay' ))) as Delay,

Siva

Re: Class Function

swuehl — Wed, 19 Apr 2017 08:49:28 GMT

Requiring open and uneven bucket sizes is not a good use case for class() function.

You could create these buckets like

If(Differenz <=30, Dual('0 - 30 Days',0),

If( Differenz <=90, Dual('31 - 90 Days',31),

If(Differenz <= 180, Dual('91 - 180 Days',91),

If(Differenz <= 365, Dual('181 - 365 Days', 181),Dual('more than 365 Days',366))

)))

Re: Class Function

beck_bakytbek — Wed, 19 Apr 2017 08:52:03 GMT

Stefan,

thanks a lot for your feedback and help, your advice helps to resolve my issue.

Thanks a lot

Beck

Re: Class Function

beck_bakytbek — Wed, 19 Apr 2017 08:52:48 GMT

Siva,

thanks a lot for your feedback and useful information about issue: Buckets

Thanks a lot