Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to multiply the "Quantity" column in the table "Orders" to the "UnitPrice" column in the table "Prices". How can I multiply these 2 fields in different tables? The tables are associated by a field called "Orders.StockCode".
2 possible way
1: using join
2: using applymap
Regards,
Prashant Sangle
If you want to perform this calculation in the script, see this post for three potential methods.
https://qlikviewcookbook.com/2020/03/creating-temporary-script-associations/
-Rob