topic Show futuristic value in chart in QlikView

Show futuristic value in chart

Tue, 26 Mar 2013 07:16:55 GMT

Hi,

I have a graph with which shows incremental value(just learned by asking in a post).

Date Value

8th 10

9th 15

10th 20

The graph shows values as

X axis Y axis

8th 10

9th 25(15 of 9th + 10 of 8th)

10th 45(20 of 10th+15 of 9th+10 of 8th)

I have a target value in variable which shows the target line at 100 and i have to reach this target in 7 days.

meaning each day if value increase by 55/4(which is (100-45)/(remaining days)) i.e. 14(approx) the target will be achieved.

need to show this graph as

X axis Y axis

8th 10

9th 25(15 of 9th + 10 of 8th)

10th 45(20 of 10th+15 of 9th+10 of 8th)

11th 59(till 10th + 14(increment))

12th 73(till 11th + 14(increment))

13th 87(till 12th + 14(increment))

14th 101(till 13th + 14(increment))

Can anyone help me with this

thanks

Aaditya Motiani