Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

beck_bakytbek
Valued Contributor III

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

Re: RangeMax () with Variable

Or this

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


Capture.PNG

7 Replies

Re: RangeMax () with Variable

How about this

Sum(RangMax(0, vTest))

Re: RangeMax () with Variable

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

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

- Marcus

beck_bakytbek
Valued Contributor III

Re: RangeMax () with Variable

Hi Sunny,

Thanks a lot for your responce

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

beck_bakytbek
Valued Contributor III

Re: RangeMax () with Variable

Hi Marcus,

thanks a lot for your responce

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

Re: RangeMax () with Variable

May be you just need this

RangeMax(0,$(vTotal))

Re: RangeMax () with Variable

Or this

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


Capture.PNG

beck_bakytbek
Valued Contributor III

Re: RangeMax () with Variable

Hi Sunny,

thanks a lot for your help, it does work

Community Browser