Use variables as arithmetic operators

[vmoreno2605]

Hi everyone!

I have an excel that is gonna be modified by a user, in this file we will have a column with the following operators (i dunno their names in english, sorry) "<=, <, >=, >, =".

I need to use them in my script like this:

Load ID, Date,
if(Date-Date>=3,1,0) as Field
Resident Table;

Using a variable instead of ">="

Thank you.

[JordyWegman · Accepted solution]

Hi Vmoreno,

You can load these math symbols in Qlik and put them in a variable, small example:

MathSymbols:
Load
  Symbol
From [MathSymbols] (qvd);

Load vMathSymbol = Peek('Symbol,0,'MathSymbols');

FinalTable:
Load
  ID,
  Date,
  IF(Date-Date $(vMathSymbol) 3, 1, 0) as Field
Resident Table;

Drop table Table;

Jordy

Climber