Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
sup
Contributor
Contributor

Get current Demension in Set Modifier

Hello,

I need get current Demension value for compare in Set Modifier
If i make like this,i can see result:

sum(aggr({$<[Paydate]={">=$(=Max([Paydate]))"}>} NoDistinct sum( [Cost]), [Order]))

But if i try like this, the result is zero:

sum(aggr({$<[Paydate]={">=[Paydate]"}>} NoDistinct sum( [Cost]), [Order]))

What should i do to get my SUM where Demension is less than current ?

 

Labels (2)
1 Reply
sunny_talwar
MVP
MVP

May be you need to use Above() or The As-Of Table