topic Adding a calculated field to an existing table in QlikView

Adding a calculated field to an existing table

lianelon — Wed, 25 Nov 2020 16:16:04 GMT

HI!

I'm new on QV and trying to add a sales revenue List box.

The sales revenue is a sum of salesprice in products table and quantity in sales table.

I figured I can add to the sales table a sales revenue field. in the script but I don't know how to do that.

I'll appreciate any help on the subject:)

Thank you in advance

Re: Adding a calculated field to an existing table

Peter_Cammaert — Thu, 24 Aug 2017 15:46:29 GMT

In script or in the UI?

If you have correctly loaded all tables, then the UI step is probably easiest. Create a straight table and add Product ID as dimension. Then add and expression like:

= Salesprice * Sum(Quantity)

Even though these fields are in different tables, QlikView will perform the necessary Joins on the fly and calculate the aggregated total.

Re: Adding a calculated field to an existing table

sasiparupudi1 — Thu, 24 Aug 2017 19:10:19 GMT

Use mapping table in the script

Map_saleprice:

Mapping Load

Productid,

Saleprice

From products;

Sale:

Load

Applymap ('Map_saleprice',productId)*quantity as salerevenu,

Field2,

Field3

From sales;

Hth

Sasi