Multiply two fields in a table and display the result on to a new column

[andymanu]

Hi,

I am currently studying the Qlik Sense scripting and would like to know a suitable syntax for the below mentioned question.

I want to multiply two fields of a table ( Ex - Unit price vs Quantity) and display the result on to a newly created table field named Sales.

I would prefer using variables and appreciate if someone could help me with the above said question.

Thanks a lot in advance.

Regards,

Manu

[shivanandk · Accepted solution]

to your script add a calculated field

Load

UnitPrice,

Quantity,

UnitPrice*Quantity as Sales

from tablename

[zebhashmi]

Use a residence Load of your table and

UnitPrice*Quantity as a new field

[andymanu]

Thank you

[andymanu]

Thank you