Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

month subtraction and addition

I'm having issue with adding and subtracting month in set analysis. can you look at it and let me the issue.

Thanks,

1 Reply
swuehl
MVP
MVP

Maybe like attached?

You can also use a pure numeric month field created in your script ( num(month(DATEFIELD)) as numMonth ), and filter your data using this field (don't forget to clear any calendar field that may conflict).

But even when using such a field, there is one potential problem at year bounderies. So it might be even better to use a date field instead of the month (maybe created by monthname() or monthstart()) and addmonths() function to step one month forward or back.

Hope this helps,

Stefan