Set Analysis

[Anonymous]

I want to show Sum of Volume based on the user selection of month and year. Also will have to show the subsequent sums of the volume for 5 months which are prior to the selected month, grouped by the month field.

Month	Year	Volume
02	2016	1
04	2016	1
07	2015	1
08	2015	1
10	2015	1
10	2015	1
10	2015	1
09	2015	1
05	2015	1
10	2015	1
01	2016	1
03	2016	1
11	2015	1
01	2016	1
10	2015	1
01	2016	1
10	2015	1

[sunny_talwar]

So what is the expected output from the sample you have provided above?

[swuehl]

I would suggest that you create a MonthYear field:

LOAD Month,

          Year,

          MonthName(Makedate(Year, Month)) as MonthYear,

          Year*12+Month as MonthYearNum

FROM ...;

Then you can use a set expression like

=Sum(

{<MonthYearNum = {">=$(=Max(MonthYearNum)-5)<=$(=Max(MonthYearNum))"}, Month, Year, MonthYear>}

Volume)

Use this in a chart with dimension MonthYear.

[Anonymous]

Thanks a lot

[swuehl]

If your request is resolved, please consider closing this thread

Qlik Community Tip: Marking Replies as Correct or Helpful