Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calculated field

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,

1 Solution

Accepted Solutions
tresesco
MVP
MVP

Like this?

Load

          Width,

          Length,

          Width*Length as  Area

From <>:

View solution in original post

4 Replies
Anonymous
Not applicable
Author

YourNewTable:

LOAD

...

Lengt*Width as Area,

....

resident YourTable;

drop table YourTable;

tresesco
MVP
MVP

Like this?

Load

          Width,

          Length,

          Width*Length as  Area

From <>:

jmvilaplanap
Specialist
Specialist

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

Not applicable
Author

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,