Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a variable called reportyear. With that I make this expression count({<year= {$(reportyear) }>} customerid)
I want to compare the outcome with previous year, to prevent making a lot of variables i am looking for a possibility to substract a value from the variable in the modifier for example:
count({<year= {"=$(reportyear) -1"}>} customerid)
That does not give the expected result, any hints ?
Qlikview version may 2021 SR1
You may use: count({<year= {"$(=$(reportyear) -1)"}>} customerid)
whereby it might be also possible to avoid the variable itself, with something like:
count({<year= {"$(=max(year) -1)"}>} customerid)
You may use: count({<year= {"$(=$(reportyear) -1)"}>} customerid)
whereby it might be also possible to avoid the variable itself, with something like:
count({<year= {"$(=max(year) -1)"}>} customerid)
Thank you Marcus that worked. max(year) does not work here because it is not the last year of my dataset.