topic Re: expression in QlikView

expression

Hamid_Reza_Rashidi — Wed, 25 Nov 2020 16:16:04 GMT

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 — Sun, 24 Nov 2019 21:07:01 GMT

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 — Mon, 25 Nov 2019 08:17:24 GMT

Variable will refer to the cell referred.

Can you post a sample ?

Hamid_Reza_Rashidi — Mon, 25 Nov 2019 10:27:46 GMT

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 — Mon, 25 Nov 2019 10:28:25 GMT