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

Announcements
Share your agentic AI experience, learn from others, and earn a new badge: Put Agentic AI to Work
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
MVP
MVP

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