topic Question on Chart Expression in QlikView

Question on Chart Expression

ramanarayan — Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

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.

Re: Question on Chart Expression

sunny_talwar — Wed, 09 May 2018 11:20:00 GMT

Try this expression for line

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

Re: Question on Chart Expression

ramanarayan — Wed, 09 May 2018 11:29:58 GMT

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

Re: Question on Chart Expression

ramanarayan — Wed, 16 May 2018 07:21:10 GMT

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

Re: Question on Chart Expression

big_dreams — Wed, 16 May 2018 07:22:34 GMT

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

Regards,