topic Re: Getting a range in set analysis (variable + 11 months) in QlikView

Getting a range in set analysis (variable + 11 months)

zagzebski — Thu, 12 Mar 2015 17:26:35 GMT

There are probably several ways to do but I need to return a sum of sales for a period equal to the value of a Year Month variable + 11 months.

For instance:

Year Month Variable = 201311 (which represents year and month)

Data (yellow represents the 12 months data I need to sum - 201311 through 201410). Obviously the issue is with a Year Month field I can't just add 11 to the variable:

Company	Sales_YearMonth	Sales
A	201309	5
A	201310	10
A	201311	15
A	201405	20
A	201406	25
A	201408	30
A	201409	35
A	201412	40
A	201501	45
A	201502	50

Thanks in advance,

Steve

Re: Getting a range in set analysis (variable + 11 months)

MK_QSL — Thu, 12 Mar 2015 17:36:42 GMT

=SUM({<,YourDateField =, YourMonthField = , YourQuarterField =, YourYearField = ,YearMonth = {">=$(=Date(AddMonths(Date#(Max(YearMonth),'YYYYMM'),11),'YYYYMM'))<=$(=Max(YearMonth))"}>}Sales)

Re: Getting a range in set analysis (variable + 11 months)

zagzebski — Thu, 12 Mar 2015 18:07:57 GMT

Thanks!!

Steve

Re: Getting a range in set analysis (variable + 11 months)

Anonymous — Wed, 30 Sep 2015 10:55:53 GMT

Sorry to "steale" this thread, but i just know this answer would help me solve my problem, but I can not get it to work.

Can someone explain it for me, and help me understand 🙂

My period is on the format YYYYMM ('acc_period'), and my Sales is amount.

What shall I Write to make this work?

Anyone? 🙂

Re: Getting a range in set analysis (variable + 11 months)

MK_QSL — Thu, 01 Oct 2015 06:24:01 GMT

Create a new Question/Thread please !

Re: Getting a range in set analysis (variable + 11 months)

anitamelbye — Thu, 01 Oct 2015 08:38:44 GMT

I got it! Thx

(After trying 50 times) 🙂