Discussion board where members can get started with Qlik Sense.
i need your support in order to create a variable.
I try to explain: I turned a date into this format YYYYMM using this script
LET VPath_xx = num(year(today())*100+month(today())) and it works fine.
Now i would like to create another variable but subtracting 12 months from the current date.
The final result should be something like this : 201710
Could you please give me some suggestion ?
Thanks in advance for your support
have a nice day
it works fine
let's try as below:
LET VVar2 = num(year(addmonths(today(), -12))*100+month(addmonths(today(), -12)));
I hope it helps.