Discussion board where members can get started with Qlik Sense.
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.
Go to Solution.
to your script add a calculated field
UnitPrice*Quantity as Sales
Use a residence Load of your table and
UnitPrice*Quantity as a new field