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

Announcements
Maximize ROI with Qlik Professional Services – Expert Guidance, Faster Results: Explore Qlik Services
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Using variables to forecast?

Hi, I am trying to calculate a quarterly forecast using current QTD runrates for 2 different dimensions (Business unit and segment). I was able to calculate the runrates for both but when I applied the runrates * the total EST using the following formula, it gave me wrong answers. Can someone help please? TIA!

sum(if(Segment = 'A', 200000, if(Segment = 'B', 300000, if(Segment = 'C', 400000, if(Business Unit = 'AA', 200000, if(Business Unit ='BB', ...)))))) * (Runrate/100)

Please see screenshot below.

5 Replies
rustyfishbones
Master II
Master II

Maybe you could try it like this

sum(if(Segment = 'A' AND [Business Unit] = 'AA',  200000, if(Segment = 'B', 300000 AND [Business Unit] ='BB' , if(Segment = 'C', 400000 AND [Business Unit] ='CC')))) * (Runrate/100)

Anonymous
Not applicable
Author

Thanks, sorry, doesn't work.... it gave me nulls instead...

Anonymous
Not applicable
Author

oh nevermind.. it's the sum... Silly me, thanks!

rustyfishbones
Master II
Master II

So it's working now?

Anonymous
Not applicable
Author

Yes! Thanks!