expression

[Hamid_Reza_Rashidi]

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

[Taoufiq_Zarra]

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

[ashwanin]

Variable will refer to the cell referred.

Can you post a sample ?

[Hamid_Reza_Rashidi]

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

[Hamid_Reza_Rashidi]

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

[Brett_Bleess]

Also check apparent duplicate post: https://community.qlik.com/t5/QlikView-Scripting/Expressions/m-p/1655511/highlight/false#M97676

Regards,
Brett