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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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