topic Bucket analysis in QlikView

Bucket analysis

Anonymous — Thu, 31 Aug 2017 04:59:30 GMT

I want do the bucketing analysis of 30 days ,60 days.90 days ,90+days ans total due

i create the bucket

Bucket Name	Min	Max
0 To 1 Months	0	30
0 To 2 Months	0	60
0 To 3 Months	0	90
3 To 6 Months	91	180
6 To 9 Months	181	270
9 To 12 Months	271	360
>12 Months	361	1000

and use 0 to 1 for 30 days and 0 to 2 for 60 days ,0 to 3 for 90 days and 3 To 6 Months','6 To 9 Months','9 To 12 Months','>12 Months

used for 90+ days and total due is sum of 30 days ,60 days.90 days ,90+days

I just want to confirm is it correct or not

Re: Bucket analysis

Anil_Babu_Samineni — Thu, 31 Aug 2017 13:25:06 GMT

The way is In memory showing correct.

But, For validation you could check this in Filters only? Will you

Re: Bucket analysis

effinty2112 — Thu, 31 Aug 2017 13:29:29 GMT

Hi Shweta,

If days = 15 what bucket would you pick? It satisfies the conditions for three buckets.

Cheers

Andrew

Re: Bucket analysis

Anonymous — Thu, 31 Aug 2017 13:33:45 GMT

correct so what should I use

Re: Bucket analysis

effinty2112 — Thu, 31 Aug 2017 13:39:01 GMT

Hi Shweta,

Try this expression to create the buckets:

Pick(

Match(-1,

Days <= 30,

Days <= 60,

Days <= 90,

Days <= 180,

Days <= 270,

Days <= 360,

-1),

'To 1 Month',

'To 2 Months',

'To 3 Months',

'To 6 Months',

'To 9 Months',

'To 12 Months',

'>12 Months')

Regards

Andrew

Re: Bucket analysis

sunny_talwar — Thu, 31 Aug 2017 13:49:49 GMT

You want to do this in the script?

Re: Bucket analysis

Anonymous — Tue, 05 Sep 2017 03:19:07 GMT

in front end

Re: Bucket analysis

Anonymous — Tue, 05 Sep 2017 04:53:31 GMT

right now I am using this bucket of due in 30 days

Bucket Name	Min	Max
0 To 1 Months	0	30
1 To 2 Months	31	60
2 To 3 Months	61	90
3 To 6 Months	91	180
6 To 9 Months	181	270
9 To 12 Months	271	360
>12 Months	361	1000

or using this exp in order to represent 0 to 3 month

=if((WildMatch([Bucket Name],'0 To 1 Months' ,'1 To 2 Months','2 To 3 Months')),'0 To 3 Months',[Bucket Name])

Re: Bucket analysis

rohitraut — Tue, 05 Sep 2017 06:18:39 GMT

Hello Shweta,

Try this,

if(Days >= 0 and Days <= 30,'To 1 Month',

if(Days <= 60,'To 2 Months',

if(Days <= 90,'To 3 Months',

if(Days <= 180,'To 6 Months',

if(Days <= 270,'To 9 Months',

if(Days <= 365,'To 12 Months',

if(Days > 365,'GRETER THAN 12 Months')))))))