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: 
Death4Free
Contributor III
Contributor III

Line chart graph interpretation

Hi! How can I interpret graph in this way ?                                   

2.PNG

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

                1.PNG

Average 9, Average 6, Average 3 are measures.

1 Solution

Accepted Solutions
dplr-rn
Partner - Master III
Partner - Master III

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

ValueList() – For those tricky situations

View solution in original post

3 Replies
dplr-rn
Partner - Master III
Partner - Master III

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

ValueList() – For those tricky situations

Death4Free
Contributor III
Contributor III
Author

Thank your for help!

dplr-rn
Partner - Master III
Partner - Master III

No problems