set analysis and dates range

Thu, 11 Feb 2016 11:39:44 GMT

Hi everyone.

I'm trying to use the set analysis to evaluate a sum between two dates.

I set two variables and my [Posting Date] field is numeric.

vMonthStart =Num(MonthStart(AddMonths(Only(MonthYear),1)))

vMonthStop =Num(AddMonths(Only(MonthYear),-11))

I'm using this expression :

=Sum({1<[Posting Date]={">$(vMonthStart) <=$(vMonthStop)"}>} [Line Amount (LCY)])

The purpose is to evaluate the sum for the past 12 months (selected MonthYear, and only one, included) but for now the sum isn't good.

I use a textbox to verify the variables and they seem right.

Example :

Selecting MonthYear to dec.-2015 give me vMonthStart = 42370 (01/01/2016) and vMonthStop = 42005 (01/01/2015) which is correct but the sum is still false.

As a reference i'm using this expression Sum({1<Year={$(vYear)}>}[Line Amount (LCY)])) and in that case the sum is correct.

I looked at countless community discussions but none fix my problem, and I obviously don't see or understand what I'm missing here.

In advance, thanks for you help and sorry for my english mistakes ... not native. ^^

Re: set analysis and dates range

swuehl — Thu, 11 Feb 2016 12:40:28 GMT

Your vMonthStart is larger than vMonthStop, so you won't select the range of dates between these two values, but the complement, AFAIR.

I think you need to exchange your definitions of Start and Stop.

topic set analysis and dates range in QlikView

set analysis and dates range

Re: set analysis and dates range