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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
suvechha_b
Creator III
Creator III

Need Assistance.....

I have attached my model.

                                                            Jul 2013              Aug 2013

Sales Plan (Planner Forecast ) : 430                         236

Projected Adjustment :                     0                               0

RISK :                                                  430                         666 

and so on....

RISK for jul 2013 ( Sales Plan(Jul 2013) - Projected Adjustment)

RISK for Aug  2013 ( RISK(Jul 2013) + Sales Plan(Aug 2013) - Projected Adjustment) and so on...

My model is working fine when I am selecting only one Fiscal Year but if I select two Fiscal year then RISK is calculating error.

I have calculated the RISK with the help of two variable vUnit and nRisks ... please check the calculation.

0 Replies