topic Re: Filtering in Diagrams with variables in QlikView

Filtering in Diagrams with variables

Wed, 05 Oct 2011 11:07:33 GMT

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.

Filtering in Diagrams with variables

lironbaram — Wed, 05 Oct 2011 11:29:27 GMT

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

Re: Filtering in Diagrams with variables

Wed, 05 Oct 2011 11:53:06 GMT

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 !

Re: Filtering in Diagrams with variables

Wed, 05 Oct 2011 13:26:06 GMT

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 ...