Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello!
I have a table thats looks something like this:
And i have a measure (Different) that looks like this and is based on the last three months (In month 8 it is month 5-7):
I want to get the different (based on last three months, 90.16%) and multiply it with last year number on the same month and make expected numbers on the months thats i left this year.
I want to have this table when im done:
Anyone that can help how im doing that?
When im trying i only get expected numbers on month 5-7.
Hi, I'm not sure to follow what's the issue, in case it helps, from one month you can access another months values using an approach like the as-of table: https://community.qlik.com/t5/Design/The-As-Of-Table/ba-p/1466130