topic How to create Bucket in QlikView

How to create Bucket

Wed, 25 Apr 2012 10:13:45 GMT

Can anybody please tell me how to create bucket

my expression is sum(z5)/sum(z6)*100

i have to create four bucket i.e 0-90,90-95,95-100

Please help me out

How to create Bucket

m_woolf — Wed, 25 Apr 2012 11:21:25 GMT

Look at the class function in help.

How to create Bucket

Wed, 25 Apr 2012 11:32:16 GMT

hi ,u can do the following in script :

if ((sum(z5)/sum(z6))*100)>0 and ((sum(z5)/sum(z6))*100)<=90, '0-90',

if((sum(z5)/sum(z6))*100)>90 and ((sum(z5)/sum(z6))*100)<=95,'90-95',

if(((sum(z5)/sum(z6))*100)>95 and ((sum(z5)/sum(z6))*100)<=100,'95-100')))

i hope it workz

How to create Bucket

Anonymous — Wed, 25 Apr 2012 14:11:22 GMT

You can also use what kuki_kuki_87 is suggestion as a calculated dimension in your charts.

How to create Bucket

jagannalla — Wed, 25 Apr 2012 14:33:31 GMT

Hope it helps you.

Use this as three different expressions, It gives each bucket wise.

0-90 -> Sum({$<BucketFieldName={">=0<90"}>} Z5) / Sum({$<BucketFieldName={">=0<90"}>} Z6) *100

90-95 -> Sum({$<BucketFieldName={">=90<95"}>} Z5) / Sum({$<BucketFieldName={">=90<95"}>} Z6) *100

95-100 -> Sum({$<BucketFieldName={">=95<100"}>} Z5) / Sum({$<BucketFieldName={">=95<100"}>} Z6) *100

How to create Bucket

Wed, 25 Apr 2012 17:01:53 GMT

Can u explain what u mean by BucketFieldName?

How to create Bucket

jagannalla — Thu, 26 Apr 2012 07:43:58 GMT

It is the fieldname which you want to apply buckets i.e, ranges 0-90,90-95.95-100.

How to create Bucket

Thu, 26 Apr 2012 08:28:26 GMT

kkk

How to create Bucket

nilesh_gangurde — Thu, 26 Apr 2012 08:32:14 GMT

Hi sumitthakur.mpvm,

You can craete bucket at load time which and use it as Dimension with the above mension expression(sum(z5)/sum(z6)*100).

write the following script in the load :

if (FieldName <= 90,'0 - 90',if(FieldName >90 and FieldName <= 95,'90 - 95',if(FieldName > 95 and FieldName <=100,'95 - 100'))) as Bucket,

Then Dimension = Bucket And Expression = sum(z5)/sum(z6)*100)

Regards,

Nilesh Gangurde

Re: How to create Bucket

Fri, 18 Jul 2014 09:07:46 GMT

hi can u explain bucket analysis for interview purpose

Re: How to create Bucket

sudeepkm — Fri, 18 Jul 2014 09:22:59 GMT

you can create a gauge chart which uses only expressions and then create different labels according to your expressions range. mostly useful when you want to visualize information dimension less.

Re: How to create Bucket

Anonymous — Thu, 04 Jun 2015 13:00:27 GMT

Hi,

You can try Class() function.

Re: How to create Bucket

buzzy996 — Thu, 04 Jun 2015 13:04:05 GMT

u can go with either class function or multi if statements.