Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
paulwalker
Creator II
Creator II

Need help?

Hi All,

How to calculate Bucket based on date

(0-30 days, 30-60 days, 60-90 days and Above 90 days) but based on current year..

Ex:

DateSales Qty
1/22/2011132
1/23/201120
1/24/201196
1/25/201134
1/26/2011138
1/27/201167
1/28/201159
1/29/201178
1/30/201136
1/31/201187
2/1/20116
2/2/2011100
2/3/201318
2/4/201187
2/5/201136
5/7/201499
5/8/201436
5/9/201430
5/10/201490
5/11/201412
5/12/201448
5/13/20149
5/14/201430
5/15/201415

here i want show current year data only.....based on year selection..

Thanks in advance........

10 Replies
paulwalker
Creator II
Creator II
Author

Hi Macro,

I need only 0-30, 31-60, 61-90, Above 90......

suppose i have 2012, 2013, 2014 years data

if i am click 2012 i want to show this year data  (0-30, 31-60, 61-90, Above 90......)

same as 2013 and 2014

by default current year data..

Here 0-30 days means (suppose today 9/18/2014 = back 30 days means 8/20/2014)

see like this

8/20/2014
8/21/2014
8/22/2014
8/23/2014
8/24/2014
8/25/2014
8/26/2014
8/27/2014
8/28/2014
8/29/2014
8/30/2014
8/31/2014
9/1/2014
9/2/2014
9/3/2014
9/4/2014
9/5/2014
9/6/2014
9/7/2014
9/8/2014
9/9/2014
9/10/2014
9/11/2014
9/12/2014
9/13/2014
9/14/2014
9/15/2014
9/16/2014
9/17/2014
9/18/2014

same as 31-60, 61-90 and Above 90  (Above 90 means 91 days to 365 days)

Hope you Understand...

please help me...