topic Re: Set analysis using variables in QlikView

Set analysis using variables

Wed, 15 Feb 2012 10:16:46 GMT

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...

Set analysis using variables

Anonymous — Wed, 15 Feb 2012 10:19:51 GMT

Hope this will be helpful for your problem

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

Regards

Ashok

Set analysis using variables

Wed, 15 Feb 2012 10:27:05 GMT

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..

Re: Set analysis using variables

Anonymous — Wed, 15 Feb 2012 10:30:13 GMT

see the attached file

Re: Set analysis using variables

Wed, 15 Feb 2012 10:40:19 GMT

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

Re: Set analysis using variables

rajeshvaswani77 — Wed, 15 Feb 2012 10:52:18 GMT

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

Re: Set analysis using variables

rajeshvaswani77 — Wed, 15 Feb 2012 10:52:36 GMT

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

Re: Set analysis using variables

Anonymous — Wed, 15 Feb 2012 10:56:32 GMT

Hope the following links will be useful for your doubt

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

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

Regards

Ashok

Re: Set analysis using variables

Anonymous — Wed, 15 Feb 2012 10:58:19 GMT

This one to usefull for your doubt

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

Regards

Ashok

Re: Set analysis using variables

Wed, 15 Feb 2012 11:14:22 GMT

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

Set analysis using variables

Mon, 20 Feb 2012 09:24:22 GMT

Hai Lavanya,

I think there is a small error on the syntax. you have mentioned =sum({< Year= { '$(vMaxyear')}>} Sales)

instead you try =sum({< Year= { '$(vMaxyear)'}>} Sales). I was able to get results with this.

Set analysis using variables

Thu, 23 Feb 2012 11:06:41 GMT

Hi Lavanya,

Try this:

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

Regards,

Shyam