Calculate Days bucket

[Karahs]

Hi everyone,

I need to calculate number of days and buckets as shown bellow with respect to following to dates:

Advanced	0-30	31-45	>45
eg.Before Posting Date	eg.Between Posting Date and Due date	eg.After Due Date + 15 days	eg. Due Date +15 days

Thanks & Regards,

Kshitija

[guruprem]

You can try something like this:

IF (

Interval(Date1-Date2,'d') < 0 , 'Advanced',

  IF ( Interval(Date1-Date2,'d') <= 30 , '0-30',

  IF ( Interval(Date1-Date2,'d') <= 45 , '31-45',

          '>45'))) as [buckets group],

[devarasu07]

Hi,

Share your sample data with excel/text format. tks

[sunny_talwar]

Have you seen here:

Buckets

and here

Dynamic Time Intervals Using Calculated Dimension In QlikView - QlikView Blog, QlikView Videos and T...