topic Line chart : Average value from start until value of point in QlikView

Line chart : Average value from start until value of point

davoud-jelodar — Thu, 22 Feb 2018 11:48:10 GMT

I have a table with these fields Symbol,Code,Value:

Symbol	Code	Value
S1	A1	110
S1	A2	100
S1	A5	105
S1	A6	108
S2	B3	120
S2	B5	150

I want to show a line chart with dim="Symbol" and exp="Value/AVG", that AVG is average of value before current value. for example for symbol=S1 and Code=A5 the AVG is 105=(110+100)/2 and for Symbol=S1 and Code=A6, AVG is 105.75=(110+100+105+108)/4.

How I can do this?

Re: Line chart : Average value from start until value of point

sunny_talwar — Thu, 22 Feb 2018 11:51:47 GMT

Do you mean to have Code as your dimension?

Re: Line chart : Average value from start until value of point

sunny_talwar — Thu, 22 Feb 2018 11:56:46 GMT

Something like this?

Re: Line chart : Average value from start until value of point

davoud-jelodar — Sat, 24 Feb 2018 05:14:07 GMT

Thanks. You help me alot.