Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Question on Chart Expression

Hi Experts,

stalwar1

I have a combo chart with 2 expression.

Expression- 1:- Sum of Sales Units

Expression -2:- Sum of Sales Units from the current month to rolling 12 months. For eg; For Jan'18, sales units is 10 units which is represented in the bar. For the same month Jan'18, the line graph should show total sales units as 2902 units (which is the sum from Jan'18 to Dec'18). For Feb the expression 2 should show from Feb'18 to Jan'18 which would be 3125 units and so on.

I need help with the expression 2 please.

Appreciate your help.

1 Solution

Accepted Solutions
Highlighted

Try this expression for line

=RangeSum(Below(Sum([Sales Units]), 0, 12))

Capture.PNG

View solution in original post

4 Replies
Highlighted

Try this expression for line

=RangeSum(Below(Sum([Sales Units]), 0, 12))

Capture.PNG

View solution in original post

Highlighted
Creator
Creator

Thank you Sunny for the quick turn around. Very much appreciated

Highlighted
Creator
Creator

stalwar1

HI Sunny,

I have one additional requirement on this topic here.

The trend line should always be static for 12 months and should not change regardless of selection in month which I will have as a saperate list box.

For eg- The current trend line does the sum of sales for 12 months when there are no filters applied. If I want to view just 4 months of data the trend line should still show the same 12 months sum and not change for just 4 months.

Attached is the qvw.

Appreciate it

Highlighted
Creator III
Creator III

Open new thread, so other people will also help you..

Regards,