Dimension Issues

Wed, 25 Nov 2020 16:16:04 GMT

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.

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 .

sample.qvw

topic Dimension Issues in QlikView

Dimension Issues