Discussion Board for collaboration related to Creating Analytics for QlikView.
I have data samples over months (Jan to July).
I also know the december value
How do i calculate (simulate?) data from July to December with :
Aug = (Dec - Jul)/5
Sept = (Dec - Aug)/4
Oct = (Dec - Sept)/3
I have no idea how to do it in qlikview
Many thanks for your help
I'm not sure to understand, could you explain your need ?
i try to do it with dummy data, i don't know it's the same as you want or not. i can try if you've provide dummy data. please check my attachment.
Lets assume i have volumes by months (Jan to July)
I know the forecast for those same volumes for December.
I need to generate a chart with the existing data (Jan to July) AND the non existing data (Aug to Nov) based on the december forecast with a linear growth from july to december with :
Aug = July + (Dec-Jul)/5
thanks for the update
Actually i know how to do it by declaring those 12 expressions.
The point is having a dynamic code for the purpose