Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Simulate date

Hi everyone,

I have data samples over months (Jan to July).

[Jan,1

Feb,2

Mar,3

Apr,4

May,5

Jun,6

Jul,7]

I also know the december value

[Dec, 20].

How do i calculate (simulate?) data from July to December with :

Aug = (Dec - Jul)/5

Sept = (Dec - Aug)/4

Oct = (Dec - Sept)/3

etc.

I have no idea how to do it in qlikview

Many thanks for your help

4 Replies
martin59
Specialist II
Specialist II

Hi,

I'm not sure to understand, could you explain your need ?

Thx

marcohadiyanto
Partner - Specialist
Partner - Specialist

Hi,

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.

regards,

Marco

Not applicable
Author

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

etc.

Not applicable
Author

hi,

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