topic Re: Expressions in QlikView

Expressions

Hamid_Reza_Rashidi — Sun, 24 Nov 2019 05:29:13 GMT

Hi, Everybody, would you please let me know , how to set an expression to use it for different cells.

for Example,

i am going to take the 2 first digits of a column and multiply it to 10.

My Table is

Row, CA,CB,CC

1,1480,2020,2223

2, 1458,2021,2224

....

...

i need a variable like followings:

Let vTwodig=Left (x,2)*10

x= any column CA,CB,CC and ....

I want to define a new column (CD) the expression which i like to use some thing like following:

vTwodig CC

and next column CE:

Vtwodig CD

Best Wishes

Re: Expressions

Yousef_Amarneh — Sun, 24 Nov 2019 10:24:27 GMT

the example is not clear, can you please provide a sample of data and the expected behavior

Re: Expressions

Hamid_Reza_Rashidi — Sun, 24 Nov 2019 10:54:56 GMT

Dear Yousef, Thanks for considering my case. This simple sample is for selecting two left digits of all rows of a column by 10. as i want to apply this formula to many columns, can i define a variable to have all things fixed expect the column hope i make i clear. if it is not clear, please let me know to provide more information.

Re: Expressions

Hamid_Reza_Rashidi — Mon, 25 Nov 2019 10:29:26 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

Re: Expressions

Brett_Bleess — Mon, 09 Dec 2019 15:06:34 GMT

Hamid, maybe a dumb question on my part, but have you considered doing things in the load script instead of via expression and creating that value as its own field in the data load? I too am having trouble grasping what it is you are really trying to accomplish with things, and I know you have now tried twice to clarify things, but it is still not really making much sense.

I think if you shift this to the load script it may be much easier, as you can take that field during the load and load it twice, once as it is, but then you can do the transformation on the next line doing your left function on it, and multiplying if need be etc. This way everything is tied into the rest of the data model. Sorry I do not have anything better, but if you can further clarify the use case etc. and again, you may need to supply a screenshot or something of what you have as far as data and what you are trying to obtain, that will likely help folks visualize things a lot better. Apologies I do not have anything better for you.

Regards,
Brett

Re: Expressions

Brett_Bleess — Mon, 09 Dec 2019 16:18:00 GMT

Also see apparent duplicate post: https://community.qlik.com/t5/New-to-QlikView/expression/m-p/1650462#M383865

Regards,
Brett