Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
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
Highlighted

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)
Highlighted

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?

Highlighted
Contributor III
Contributor III

The variable definition remained the same Sunny.

Regards,

Rahul

Highlighted
MVP
MVP

Could you share a representative sample qvw to investigate?