Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
beck_bakytbek
Master
Master

RangeMax () with Variable

Hi Folks,

i am using thing this expression : Sum(RangeMax(0,A-B)) and it does work, but if i put the expression : A - B in a Variable like:

vTest = A - B and use in this expression:

Sum(RangMax(0, $(vTest))) then this expression does not work.

Does anybody kwow how to resolve this issue?

Thanks a lot

Beck

1 Solution

Accepted Solutions
sunny_talwar

Or this

Sum(Aggr(RangeMax(0,$(vTotal)), Projekt))


Capture.PNG

View solution in original post

7 Replies
sunny_talwar

How about this

Sum(RangMax(0, vTest))

marcus_sommer

Is it just a typo by the function-name and a "e" is missing, like:

Sum(RangeMax(0, $(vTest)))

- Marcus

beck_bakytbek
Master
Master
Author

Hi Sunny,

Thanks a lot for your responce

i tried, but it does not work (please see attached file)

beck_bakytbek
Master
Master
Author

Hi Marcus,

thanks a lot for your responce

i tried that way, but it does not work (please see the attached file)

sunny_talwar

May be you just need this

RangeMax(0,$(vTotal))

sunny_talwar

Or this

Sum(Aggr(RangeMax(0,$(vTotal)), Projekt))


Capture.PNG

beck_bakytbek
Master
Master
Author

Hi Sunny,

thanks a lot for your help, it does work