Calculated field

[#1]

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,

[Anonymous]

YourNewTable:

LOAD

...

Lengt*Width as Area,

....

resident YourTable;

drop table YourTable;

[tresesco · Accepted solution]

Like this?

Load

          Width,

          Length,

          Width*Length as  Area

From <>:

[jmvilaplanap]

Hi

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

[#5]

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,