topic Re: buckets in dimension in QlikView

buckets in dimension

Anonymous — Thu, 16 Aug 2012 12:44:47 GMT

HI,

i need to create a chart that shows how with how many procents an increase is and bucket those increse procentages by 10 (i.e. 0-10, 11-20, etc).

i want those buckets on the x-axis. on the y-axis i need the procentage of how many articles that has got that increase. am i making any sense? Is this possible?

Thanks in advance!

//A.

Re: buckets in dimension

MayilVahanan — Thu, 16 Aug 2012 12:50:41 GMT

Try like this,

=Class( procents ,10) as dimension

Hope it helps

Re: buckets in dimension

Anonymous — Thu, 16 Aug 2012 12:56:36 GMT

Hi,

No it doesn't... i need to calculate the percentage so it's not a field it self. has that got something to do with it?

Re: buckets in dimension

MayilVahanan — Thu, 16 Aug 2012 13:41:24 GMT

Then you can try with if condition..

Like if(procents <= 10, '1-10', if(procents <=20,'11-20','others'))