Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
ramanarayan
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
sunny_talwar

Try this expression for line

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

Capture.PNG

View solution in original post

4 Replies
sunny_talwar

Try this expression for line

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

Capture.PNG

ramanarayan
Creator
Creator
Author

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

ramanarayan
Creator
Creator
Author

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

big_dreams
Creator III
Creator III

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

Regards,