Discussion board where members can get started with Qlik Sense.
I’m working in the Data Load Editor in QLIK Sense. I want limit my data by reviewing two dates.
Booked_Date and Snapshot_Date. The Snapshot_Date is always the first day of the Month
The Booked_Date needs to be 3 months prior to the Snapshot_Date. I’m thinking to subtract the Number of Months between the two dates. If they equal to 3 get the data.
I can’t figure out the Syntax to do this. Below are examples of what I’m working with
Thank you in advance
Go to Solution.
I tried this code and I was getting errors and couldn't load the data. So I took your concept and tweeked it to this:
MonthName(AddMonths(Snap_Shot_Dt,-3)) = MonthName(Booked_Dt)
And this works perfect. Thanks for getting me started. I'm learning a lot.
May be like this:
Where ((Year(Snapshot_Date) * 12) + Month(Snapshot_Date)) - ((Year(Booked_Date) * 12) + Month(Booked_Date)) = 3;