topic Re: Calculated field in QlikView

Calculated field

Wed, 25 Nov 2020 16:16:04 GMT

Hello, I'm new to Qlikview and I want to calculate a field from the fields of a table. The table has the fields Length and Width and I want to calculate Area = Length * Width. As I do?

I am still using Qlikview Personal Edition so I would be grateful if you would send the answer in jpg or text.

Thank you very much,

Re: Calculated field

Anonymous — Wed, 05 Jul 2017 07:18:39 GMT

YourNewTable:

LOAD

...

Lengt*Width as Area,

....

resident YourTable;

drop table YourTable;

Re: Calculated field

tresB — Wed, 05 Jul 2017 07:24:00 GMT

Like this?

Load

Width,

Length,

Width*Length as Area

From <>:

Re: Calculated field

jmvilaplanap — Wed, 05 Jul 2017 14:45:49 GMT

If the format of the values is a number, there is not more problem that write the formula, if not, you must to convert the values to numbers.

Regards

Re: Calculated field

Thu, 06 Jul 2017 11:27:37 GMT

Thanks a lot Tresesco. I should have mentioned that I don´t know anything about SQL and as a former programmer in Pascal, C, etc., I was trying something like Area=length*width. After your tip and some struggle with punctuation and syntaxis I finally got it.

Thanks again,