Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, everybody,
Can i define an expression , a complicated (including several lines) expression, and apply it for any Column,
for instance,
Let vYear_M: if ((Mid(CelC1,4,2)>11, Left(CelC1,2)+622,Left(CelC1,2)+621))
and when i want to use it for other cells (Column) by writing the formula
vYear_M (CelC2)
it apply the same above formula.
Best wishes
Hi Hamid,
your question is not clear.
can you give us more details, an example it will be perfect.
one thing that is certain, you can use an expression in a variable and use it as much as you want
Taoufiq
Variable will refer to the cell referred.
Can you post a sample ?
Hi, thanks for your reply
please do check the following sample.
Let x=left(y,2)
"y" is one of my column in a table.
if i writ the formula the same as followings:
Let x=left(,2)
can i use varible x to calculate the 2 left digits of column z. (=Left(z,2))
= x (Z),
the the answer be the same as = left(Z,2),
Best regards
Hi, thanks for your reply
please do check the following sample.
Let x=left(y,2)
"y" is one of my column in a table.
if i writ the formula the same as followings:
Let x=left(,2)
can i use varible x to calculate the 2 left digits of column z. (=Left(z,2))
= x (Z),
the the answer be the same as = left(Z,2),
Best regards
Also check apparent duplicate post: https://community.qlik.com/t5/QlikView-Scripting/Expressions/m-p/1655511/highlight/false#M97676
Regards,
Brett