topic Excluding current month data in set analysis in QlikView

Excluding current month data in set analysis

lucasdavis500 — Wed, 25 Nov 2020 16:16:04 GMT

I have a variable I use to only show data from the previous month, as well as a two month lag

vPreviousMonth = "$(=Month(AddMonths(Date(Today()),-1)))"

vTwoMonthLag = "$(=Month(AddMonths(Date(Today()),-2)))"

stored in my variable overview. I changed these formulas to try to also do the most current month:

vCurrentMonth = "$(=Month(AddMonths(Date(Today()),-2)))"

vCurrentMonth = "$(=Month(Date(Today()))))"

In set analysis I'm trying to do exclude the most current month from charts using this formula:

Month -= {$(vCurrentMonth)}

but it's not working, however when I try to just view a two month lag, or previous month data with the top formulas it seems to work, does anyone have any insight into this?

Re: Excluding current month data in set analysis

sunny_talwar — Fri, 11 Nov 2016 14:43:06 GMT

Do you have one extra parenthesis in the end it seems here. Try this:

vCurrentMonth = "$(=Month(Date(Today())))"

Re: Excluding current month data in set analysis

lucasdavis500 — Fri, 11 Nov 2016 14:51:37 GMT

Haha... must have missed that... thanks for catching it, I was trying all different sorts of ways to go about this and couldn't seem to get it right.