topic Re: rangesum problem...? in QlikView

rangesum problem...?

Thu, 06 Feb 2014 04:28:02 GMT

I have the following data:

Year Month Sales

2013	1	1000
2013	2	2000
2013	3	3000
2013	4	4000
2013	5	5000
2013	6	6000
2013	7	7000
2013	8	8000
2013	9	9000
2013	10	10000
2013	11	11000
2013	12	12000

I need to select a month and the graph has to show the sales of that month + previous month

example:

if I choose month = 4

The graph should show: 7000

is that range sum or set-analysis?

Re: rangesum problem...?

Thu, 06 Feb 2014 04:42:17 GMT

try this

sum({$<Month={'>=$(=max(Month-1))<=$(=max(Month+1))'}>}Sales)

Re: rangesum problem...?

tresB — Thu, 06 Feb 2014 04:45:03 GMT

You can do it both ways. If you have doubt, prepare a sample app and share. It would be easier to help you there. See how to prepare sample for uploading

Re: rangesum problem...?

Thu, 06 Feb 2014 04:46:40 GMT

sorry some mistakes in my above post

try this

=sum({$<Month={'>=$(=max(Month-1))<=$(=max(Month))'}>}Sales)

Re: rangesum problem...?

Thu, 06 Feb 2014 04:49:48 GMT

see attached file

Re: rangesum problem...?

Sokkorn — Thu, 06 Feb 2014 04:50:24 GMT

Hi,

Use this set analysis: =Sum({<Month = {">=$(=Max(Month)-1)<=$(=Max(Month))"} >} Sales)

Regards,

Sokkorn

Re: rangesum problem...?

er_mohit — Thu, 06 Feb 2014 05:05:47 GMT

Try this

Sum({<Month = {'>=$(=Max(Month)-1)<=$(=Max(Month))'} >} Sales)

Re: rangesum problem...?

Thu, 06 Feb 2014 11:18:15 GMT

This one works! but in separate bars in the graph...
I need that the graph show the sum like if I choose month 4...the chart in one bar must show 7000...(4000+3000):

thanks

Re: rangesum problem...?

Thu, 06 Feb 2014 12:07:00 GMT

Good Example, but I need like the green bar in the picture..

how could I do that?