topic Re: Bucketing in bar Chart-Class function in QlikView

Bucketing in bar Chart-Class function

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

With reference to the example shared by Manish Kachhia in below post i want to show '0' as a separate dimension. where Age=0 is grouped.

Defining Dynamic Buckets at runtime | Qlik Community

Re: Bucketing in bar Chart-Class function

prat1507 — Mon, 31 Jul 2017 11:40:12 GMT

hI Surya

and what about the grouping, do we need to retain that?

Re: Bucketing in bar Chart-Class function

suryaa30 — Mon, 31 Jul 2017 11:42:58 GMT

Yes the grouping needs to be dynamic as its. I just want to add the 0 as dimension apart from the other grouping.

For example if the bucket is 8, currently the distribution is 0-8,8-16,16-24 etc

I want 0,(>0)-8,8-16,16-24..etc

Re: Bucketing in bar Chart-Class function

sunny_talwar — Mon, 31 Jul 2017 11:43:36 GMT

Try this

=IF(Num(Age)>0,DUAL(Replace(Class(Age,$(vBucketWIdth)),'<= x <',' - '),Class(Age,$(vBucketWIdth))+1), Num(0.0000001, '#.'))

Re: Bucketing in bar Chart-Class function

suryaa30 — Mon, 31 Jul 2017 11:53:37 GMT

Thanks Sunny. This looks good. I will try to replicate this on my original requirement. Can you please explain this part Num(0.0000001, '#.')

i was trying with 0 instead in place of Num(0.0000001, '#.') and what difference does it make.

Re: Bucketing in bar Chart-Class function

sunny_talwar — Mon, 31 Jul 2017 11:56:16 GMT

Not sure why but 0 was not showing up... so I incremented its value by a very small number 0.0000001, but then it showed 0.0000001 in the dimension. So, I used Num() function to show just 0

Re: Bucketing in bar Chart-Class function

asheppardwork — Tue, 12 Feb 2019 15:03:23 GMT

Is there anyway to do this in QlikSense? We don't have QlikView so I can't download your .qvw and get anything but the xml that is at the trailing end of the file. However, I can't seem so shoe-horn it into QlikSense.

Re: Bucketing in bar Chart-Class function

Ravindra1 — Fri, 14 Feb 2020 11:48:42 GMT

Hi Mate,

Is it possible 0-5, i need starts from 6-10..e.t.c

Is it possible, Please let me know.

Thanks & Regards,

Ravindra Babu G