topic Buckets using Class function in QlikView

Buckets using Class function

Sat, 13 Sep 2014 00:27:31 GMT

Hello,

I have created some buckets (0-10, 10-20, 20-30...) using class function for the data that I have. The problem is that most of the data has value '0' so the first bar is really long as compared to other bars. Is there a way to have to data match to the first bar only if the value is greater than 0? I tried using offset 1 and also tried using if function in the expression to calculate the counts only if value is greater than 0 but somehow it doesn't work.

Please help.

thanks,

Manoj

Re: Buckets using Class function

JonnyPoole — Sat, 13 Sep 2014 00:37:33 GMT

If your class function is this: class( Value,10)

then change it to:

if ( Value > 0 , class(Value,10))

this is done on the dimension

Re: Buckets using Class function

Sat, 13 Sep 2014 02:11:50 GMT

Ah, it was that simple. I used 'if' function everywhere else but here 🙂

thanks!