topic Re: Set Analysis confusion in QlikView

Set Analysis confusion

adnan_rafiq — Fri, 13 May 2016 00:57:55 GMT

Hi Experts.

I am having a weird experience with set analysis. Here are my expressions.

=sum({<MONTH={'01/02/2016'}>} DATA)

=sum({<MONTH={"=$(vL.AMaxMon)"}>} DATA)

where

=$(vL.AMaxMon) is max({<DATA_STATUS={'ACTUAL'}>}MONTH) which evaluates to 01/02/2016

That should be the same as sum({<MONTH={'01/02/2016'}>} DATA) but I see different results of sum.

Are there limitations of some kind on set analysis.

I am showing this is text boxes. Can some one help??

Re: Set Analysis confusion

sunny_talwar — Fri, 13 May 2016 01:16:02 GMT

Can you try this:

=Sum({<MONTH={'$(=$(vL.AMaxMon))'}>} DATA)

or this

=Sum({<MONTH={'$(=vL.AMaxMon)'}>} DATA)

Re: Set Analysis confusion

adnan_rafiq — Fri, 13 May 2016 01:20:15 GMT

Thanks for prompt suggestion Sunny

=Sum({<MONTH={'$(=vL.AMaxMon)'}>} DATA)

gives

Error: Error in set modifier ad hoc element list:

',' or ')' expected

But

=Sum({<MONTH={'$(=$(vL.AMaxMon))'}>} DATA)

works can you explain why?

Re: Set Analysis confusion

sunny_talwar — Fri, 13 May 2016 01:28:32 GMT

I guess we need to use something that can replace 01/02/2016 in the set analysis. Whatever that thing is, need to be expanded using $(=...). My guess is that if you put $(vL.AMaxMon) in a text box, it would expand to this -> 01/02/2016.

So this is what I usually do. Whatever I need in my set analysis, I create that in the text box object and then copy the whole thing and paste it into my dollar sign expansion. Does that make sense?

Re: Set Analysis confusion

adnan_rafiq — Fri, 13 May 2016 01:45:53 GMT

Thanks A Million stalwar1‌

Re: Set Analysis confusion

sunny_talwar — Fri, 13 May 2016 01:47:59 GMT

Not a problem, I am glad I was able to help