topic Re: Creating Buckets in QlikView

Creating Buckets

raju_salmon — Tue, 29 Dec 2015 07:02:22 GMT

Hi All,

I have requirement to show transaction length in buckets. I need to show buckets like <2 hours, 2-4hours,4-6hours....so on till <7days.

Trans_ID	Vendor	Trans length in seconds
1	A	1236
2	B	1548
3	A	2368
4	C	1568797
5	A	468
6	A	123578
7	B	12356879

I need to show bucket and vendor as dimension (Is it possible?) and need to see how many transaction falls and each bucket.

Can i create bucket like this?

If (Trans length in seconds<=7200, '<2 hours',

If (Trans length in seconds>7200 and Trans length in seconds<14000, '2-4 hours',))... so on...as Bucket

And can i use bucket and vendor as dimension and count (Trans_ID) as expression?

Can you please tell if any easy way to do this? or am i following correct way?

Thanks.

Raju

Re: Creating Buckets

PrashantSangle — Tue, 29 Dec 2015 07:11:44 GMT

Hi,

check Buckets‌

Might help you.

Regards

Re: Creating Buckets

raju_salmon — Tue, 29 Dec 2015 07:14:52 GMT

Thanks max. In that example i have found only Bucket dimension.

Can i use multiple dimension when i use Bucket as dimension?

Re: Creating Buckets

PrashantSangle — Tue, 29 Dec 2015 07:24:13 GMT

Hi,

Yes it is possible.

Regards

Re: Creating Buckets

Anonymous — Tue, 29 Dec 2015 07:29:01 GMT

What exactly you mean to say?

like this?

=if((Dim1>10 and Dim1<20),if((Dim2>10 and Dim2<20),'10-20')) as Bucket

Re: Creating Buckets

Peter_Cammaert — Tue, 29 Dec 2015 08:26:59 GMT

If created in your load script, Bucket becomes just another field with a transaction property. Just like Vendor is a transaction property. You can use Bucket like any other field, in chart dimensions, expressions, set analysis, variables, conditional show (for example to display all transaction details for category '>= 7 days' e.g. the bad ones)

Re: Creating Buckets

raju_salmon — Tue, 29 Dec 2015 13:10:17 GMT

Thanks peter, i have created like you suggestion.

Re: Creating Buckets

MarcoWedel — Thu, 31 Dec 2015 01:23:36 GMT

Hi,

one solution could be to create a bucket field in the script using an expression like:

Dual(Floor([Trans length in seconds]/3600,2)&' - '&(Floor([Trans length in seconds]/3600,2)+2)&' hours',Floor([Trans length in seconds]/3600,2)) as TransLength;

tabTrans:
LOAD *,
    Dual(Floor([Trans length in seconds]/3600,2)&' - '&(Floor([Trans length in seconds]/3600,2)+2)&' hours',Floor([Trans length in seconds]/3600,2)) as TransLength;
LOAD RecNo() as Trans_ID,
    Chr(64+Ceil(Rand()*20)) as Vendor,
  fabs(Ceil(NORMINV(Rand(),0,1/'00:00:01'))) as [Trans length in seconds]
AutoGenerate 30000;

hope this helps

regards

Marco

Re: Creating Buckets

vikasmahajan — Fri, 01 Jan 2016 08:23:33 GMT

PFA

Vikas