Filtering in Diagrams with variables

[#1]

Hello QV-Community,

I would like to use a if expression to write a value from a variable. The variable is already defined in the variable window and has the current value of 0.
Now, when I write my formula expression with a 0, it works perfect.

Like this:

=if

    (

     ( min(date#(HEL_DATA_Datum,'DD.MM.YYYY')) - min (SAL_OPPORTUNITYLINEITEM_von_Datum__c)) = 0 ,

     ( min(date#(HEL_DATA_Datum,'DD.MM.YYYY')) - min (SAL_OPPORTUNITYLINEITEM_von_Datum__c)),

     'x'

    )

However when I try to replace the 0 by a variable (varLimit) it doesnt work !!

Like this:

=if

    (

     ( min(date#(HEL_DATA_Datum,'DD.MM.YYYY')) - min (SAL_OPPORTUNITYLINEITEM_von_Datum__c)) = $(varLimit) ,

     ( min(date#(HEL_DATA_Datum,'DD.MM.YYYY')) - min (SAL_OPPORTUNITYLINEITEM_von_Datum__c)),

     'x'

    )

What am I doing wrong here ? Please give me a tip. Thank you.

[lironbaram]

just a thought change the variable to varLimit with out the $ sign

[#3]

Hallo,

i tried it without the $ sign.

But doesnt work with ... = (varLimit) ...

If i use the expression ... <= (varLimit)... or ...>= (varLimit)... it works perfectly !

I need to match with  ... = (varLimit)..

Can anybody help me ?. thank you !

[#4 · Accepted solution]

Hi,

I still do not understand why the QV expression = varLimit dont works when the variable takes the value 0

Unfortunately I had to create workarounds one by one I take the 0 expression of a range with varLimitMin = 0 and have done with varLimitMax = 0.

Example: if( ....(x <= varLimitMin) AND (x >= varLimitMax),......

At least it works ...