topic Set Analysis Issue in QlikView

Set Analysis Issue

rahulsingh12 — Wed, 08 Nov 2017 11:09:01 GMT

Hi,

I have written the following code which works fine

sum({<DateNew={"=$(=vL3MMax)"}>}[Volume(HL)]) gives 123

But as soon as I want the sum for the datenew greater than vL3MMax then It gives 0.

vL3MMax=AddYears(MAX(DateNew),-1) gives 0

sum({<DateNew={">=$(=vL3MMax)"}>}[Volume(HL)])

what is that I am doing wrong.

Regards

Rahul

Re: Set Analysis Issue

Anil_Babu_Samineni — Wed, 08 Nov 2017 11:24:41 GMT

May be this?

sum({<DateNew={">=$(=$(vL3MMax))"}>}[Volume(HL)])

Re: Set Analysis Issue

sunny_talwar — Wed, 08 Nov 2017 12:24:12 GMT

The variable definition stayed the same between the 2 tests? the only thing that changed was the addition of >=? or did you change the variable definition also?

Re: Set Analysis Issue

rahulsingh12 — Thu, 09 Nov 2017 04:41:56 GMT

The variable definition remained the same Sunny.

Regards,

Rahul

Re: Set Analysis Issue

tresB — Thu, 09 Nov 2017 05:03:56 GMT

Could you share a representative sample qvw to investigate?