Discussion Board for collaboration related to QlikView App Development.
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??
Can you try this:
=Sum({<MONTH={'$(=$(vL.AMaxMon))'}>} DATA)
or this
=Sum({<MONTH={'$(=vL.AMaxMon)'}>} DATA)
Can you try this:
=Sum({<MONTH={'$(=$(vL.AMaxMon))'}>} DATA)
or this
=Sum({<MONTH={'$(=vL.AMaxMon)'}>} DATA)
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?
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?
Thanks A Million stalwar1
Not a problem, I am glad I was able to help