topic Re: Set Analysis in QlikView

Set Analysis

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

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

Re: Set Analysis

sunny_talwar — Thu, 26 May 2016 11:38:33 GMT

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

Re: Set Analysis

swuehl — Thu, 26 May 2016 11:38:38 GMT

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.

Re: Set Analysis

Anonymous — Thu, 26 May 2016 14:04:01 GMT

Thanks a lot

Re: Set Analysis

swuehl — Thu, 26 May 2016 17:21:57 GMT

If your request is resolved, please consider closing this thread

Qlik Community Tip: Marking Replies as Correct or Helpful