topic Set Analysis Logic in QlikView

Set Analysis Logic

alvinford — Tue, 18 Mar 2014 23:04:41 GMT

Hi All,

I am using the following expression. The results are correct.

Sum($(=Only(AreaThisYear)))

I want to add some conditions and add it to the set analysis expression as below but not getting the desired results.

=if($(vTodaysYear)=Right(vSelectStartDate,4) AND $(vTodaysYear)=Right(vSelectEndDate,4) ,

sum({<AreaMonthYear = {">=$(vSelectStartDateMY)<=$(vSelectEndDateMY)"},Year={'$(vTodaysFYear)'}>}$(=Only(AreaThisYear))))

Kindly suggest the solution. Can we use Sum along with only in the set analysis.

Regards,

Alvin

Re: Set Analysis Logic

Clever_Anjos — Tue, 18 Mar 2014 23:21:40 GMT

I´ve never seen such use of Only.

Why do you need this nested aggregation?

Re: Set Analysis Logic

javier_florian — Tue, 18 Mar 2014 23:29:25 GMT

Hi AlvinFord,

I work with modification data in set expression, for instance:

Count(

{<Year_Month={">=$(=Num(If(Num(Right(Max(Year_Month),2))=2,(Max(Year)-1)&'12',If(Num(Right(Max(Year_Month),2))=1,(Max(Year)-1)&'11',(Max(Year_Month))-2))))<=$(=Num(Max(Year_Month)))"},Día={"<=$(=If(Day(Max(Fecha))>=25,31,Day(Max(Fecha))))"}>}

Distinct Emisiones.Certificado)

Tell us if this work for you.

-JFlorian