Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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