Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

andymanu
Contributor

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

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

1 Solution

Accepted Solutions
shivanandk
Contributor II

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

to your script add a calculated field

Load

UnitPrice,

Quantity,

UnitPrice*Quantity as Sales

from tablename

4 Replies
shivanandk
Contributor II

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

to your script add a calculated field

Load

UnitPrice,

Quantity,

UnitPrice*Quantity as Sales

from tablename

zebhashmi
Valued Contributor

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

Use a residence Load of your table and

UnitPrice*Quantity as a new field



andymanu
Contributor

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

Thank you

andymanu
Contributor

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

Thank you

Community Browser