Variables in condition

[maxime66]

Hy Qlikers,

I would to put a condition using result of my variable 'Sens' (>= or =< ) and filter my orange table.

It's working but i would like not to test the result of  'Sens' with IF statement ...

something like :

= if(sales $(Sens) Amount,customer,null())  ---> = if (sales >= 15 ,customer,null() )

Thx !

[maxime66]

sorry

.... I would like to put​ ...

[sunny_talwar · Accepted solution]

Seems to be working, what is the issue?

[maxime66]

Ouch , i thought it will not work cause of the error underline... but i does !!

thx Sunny

[sunny_talwar]

Ya ignore those red underlines because that just means that the syntax is not understood by expression editor. Always try to check if you are getting the desired result or not regardless of what the expression editor says