Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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,