Set analysis using variables

[#1]

Hi All,

    I have a very minor issue.. I below setanalysis expression is not working.. can some one let me know that the error is?

=sum({< Year= { '$(vMaxyear')}>} Sales)

vMaxYear is the variable which has the value of Maximum year...

Thanks  in advance...

[Anonymous]

Hi

     Hope this will be helpful for your problem

     =sum({< Year= {$(vMaxyear)}>} Sales)

Regards

Ashok

[#3]

Hi Ashok,

         Sorry it is not working.The same condition is workinf fine if I use IF condition.. I think the way the value is pulled from the variable is not correct i suppose..

[Anonymous]

hi

     see the attached file

[#5]

Hi,

The set analysis is working fine but no sure why the values are different when i do the same thing with IF condition...

sum(if(Year= vMaxYear,Sales))

using set analysis

sum({ $< Year = {$(vMaxYear)}>} Sales)

..

The results for both are appering different.. This is my problem currently

[rajeshvaswani77]

Hi Lavanya,

The set analysis value will be the correct one. Takes the sum of set of all the sales for the variable in the year. The first one vMaxYear is not in the variable syntax i.e. $(vMaxYear)

thanks,

Rajesh Vaswani

[rajeshvaswani77]

Hi Lavanya,

The set analysis value will be the correct one. Takes the sum of set of all the sales for the variable in the year. The first one vMaxYear is not in the variable syntax i.e. $(vMaxYear)

thanks,

Rajesh Vaswani

[Anonymous]

Hi

          Hope the following links will be useful for your doubt

http://community.qlik.com/message/1987

http://community.qlik.com/message/172683

Regards

Ashok

[Anonymous]

hi

     This one to usefull for your doubt

     http://community.qlik.com/thread/38560

Regards

Ashok

[#10]

Hi Rajesh,

            Even the syntax is not followed in the if condition it works fine... But I am worried what could be the reasons for difference in the values when I use set analysis and IF condition..

Thanks