Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Need help in Calculated Dimension

Hi

I facing an issue to create a calculated dimension, i need to show forecast-Plan and forecast- Actual value as separate dimension in the chart.

Forecast is nothing but 1+11 F,2+10 F ,3+09 values

Please find attached pic as reference.

Capture.PNG

Above is the object i have created along with this i need other dimension as:

Forecast-Plan  & Forecast-Actuals


Forecast-Plan            -40  for Jan month(Formula-(1+11 F - Plan i.e 10-50=-40)      

                               -8  for Feb month(Formula-(2+10 F - Plan i.e 21-29=-8)


same way for remaining as well till December month


Here is sample file and qvw please find .      

0 Replies