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: 
Anonymous
Not applicable

Created Current Month, Last Month Buckets

I want to create a new field in my load script that takes a date (MM/DD/YYYY) and puts it in a current month, last month, etc .. bucket

Also wonder if I can do this with rolling weeks ... i.e make a new field that says, last 4 weeks, last 8 weeks, last X weeks ...

Thank you,

- dave

1 Solution

Accepted Solutions
sunny_talwar

You should be able to do like this

If(Date >= MonthStart(Today()), 'Current Month',

If(Date >= MonthStart(Today(), -1), 'Last Month')) as Flag

Similar idea should apply for weeks

View solution in original post

1 Reply
sunny_talwar

You should be able to do like this

If(Date >= MonthStart(Today()), 'Current Month',

If(Date >= MonthStart(Today(), -1), 'Last Month')) as Flag

Similar idea should apply for weeks