topic Simulate date in QlikView

Simulate date

Mon, 08 Aug 2011 08:17:07 GMT

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

Simulate date

martin59 — Mon, 08 Aug 2011 09:50:07 GMT

Hi,

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

Thx

Re: Simulate date

marcohadiyanto — Mon, 08 Aug 2011 10:00:22 GMT

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

Simulate date

Mon, 08 Aug 2011 10:00:43 GMT

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.

Simulate date

Mon, 08 Aug 2011 10:04:04 GMT

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