Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
AndreasMoller
Contributor III
Contributor III

Expected number based on last three months

Hello!

I have a table thats looks something like this:

AndreasMoller_0-1691653259667.png

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):

AndreasMoller_1-1691653340101.png

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:

AndreasMoller_2-1691653467225.png

Anyone that can help how im doing that?

When im trying i only get expected numbers on month 5-7.

 

Labels (1)
1 Reply
rubenmarin

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