topic Re: Line chart graph interpretation in QlikView

Line chart graph interpretation

Death4Free — Fri, 28 Sep 2018 16:02:08 GMT

Hi! How can I interpret graph in this way ?

But not in this way, like it happen now (3 measures added to line chart)

Average 9, Average 6, Average 3 are measures.

dplr-rn — Fri, 28 Sep 2018 16:21:10 GMT

Use value list

e.g. dimension

=ValueList('9 Month','6 Month','3 Month')

expression

if (ValueList('9 Month','6 Month','3 Month') = '9 Month',

Avg( {<OrderDate={"<=$(=Max(OrderDate)) >=$(=AddMonths(Max(OrderDate),-9))"}>} LineSalesAmount),

If( ValueList('9 Month','6 Month','3 Month') = '6 Month',

Avg( {<OrderDate={"<=$(=Max(OrderDate)) >=$(=AddMonths(Max(OrderDate),-6))"}>} LineSalesAmount),

Avg( {<OrderDate={"<=$(=Max(OrderDate)) >=$(=AddMonths(Max(OrderDate),-3))"}>} LineSalesAmount)))

check link for some theory

Death4Free — Fri, 28 Sep 2018 21:31:03 GMT

Thank your for help!

dplr-rn — Fri, 28 Sep 2018 22:08:53 GMT

No problems