Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
rahulsingh12
New Contributor III

Set Analysis Issue

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

4 Replies

Re: Set Analysis Issue

May be this?

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


Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

Re: Set Analysis Issue

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?

rahulsingh12
New Contributor III

Re: Set Analysis Issue

The variable definition remained the same Sunny.

Regards,

Rahul

MVP
MVP

Re: Set Analysis Issue

Could you share a representative sample qvw to investigate?