topic Re: Class function in QlikView

Class function

cbushey1 — Wed, 14 Feb 2018 19:50:13 GMT

Does anyone know if there is a way to have the buckets of a class function not repeat the right limit in the next bucket?

So lets assume the output of my class function returns the following:

0 <= x < 20

20 <= x < 40

40 <= x < 60

Is there a way that I can have the following instead?

0 <= x < 19

20 <= x < 39

40 <= x < 59

I plan to use the replace function so that I ultimately get

0 to 19

20 to 39

40 to 59

I am trying to do this in the script instead of a calculated dimension and I having to first generate a list of possible values between a min and max so I can have all the buckets appear in this field.

TIA -

Re: Class function

petter — Wed, 14 Feb 2018 22:45:30 GMT

What about the values 19 and 39? They are not within any of the bins?

Is it this that you want:

0 <= x <= 19 then it's the same as 0<=x<20

20 <= x <= 39

40 <= x <= 59

Then this works:

Class(Field,20)

And to make it with your logic of using to and being inclusive with lower and upper value:

SubField(Class(F,20,''),'<= <',1)&' to '&(SubField(Class(F,20,''),'<= <',2)-1)

Re: Class function

cbushey1 — Thu, 15 Feb 2018 14:11:47 GMT

Hi Petter,

Thanks for the reply. I didnt even think about using subfield on this so I believe that will show my desired result.

To answer your questions though, 19 and 39 were contained in the bins and it is true that the returned values of 0 <= x <20 would be the same as 0<= x <= 19, the display is what I needed to change. It is confusing to the user once you remove the <= x < signs, where the value 20 is found. Is it in the first range (now 0 to 20) or is it in the second range (20 to 40)? So that is why I needed a solution as you proposed. Thanks again.

Re: Class function

petter — Thu, 15 Feb 2018 14:13:27 GMT

Happy to be of help