Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
evansabres
Specialist
Specialist

Calculation between two tables in a script

I have two tables in my script, 'Reference' and 'Sales' They are joined by a common field called 'Price Scale Display'

Within the 'Reference table is a field called 'Price'

Within the 'Sales' table is a field called 'Seats'

Within my script, i would like to multiply those two fields together to create a new field called 'Revenue'

How can I achieve this?

1 Solution

Accepted Solutions
dilipranjith
Partner
Partner

why do you need to do in script? you can do that in expression.

if you have to do in script you will need to join the tables together and then perform the multiplication between 2 fields

View solution in original post

2 Replies
dilipranjith
Partner
Partner

why do you need to do in script? you can do that in expression.

if you have to do in script you will need to join the tables together and then perform the multiplication between 2 fields

evansabres
Specialist
Specialist
Author

You are correct, joining the tables was an unneccesary step.