Question: Howw to Sum Volume * Cost and Volume * Selling Price

[Anonymous]

Hi,

I am trying to create a "measure" in Qlik Sense Data Load Editor, and i have the following data set in my data load already.

In order to find out my total revenue, i have to use Selling price *Volume? Is there a formula which i can do that in the data load editor?

EG: How to get to total sales of ABC product in Aug ($49.50 * 88000 units)?

ProductFamilyCode	ProductFamily	Label	Price	ThePeriod
ABC	ABC Product	Selling Price	49.5	8/1/2018
ABC	ABC Product	Volume	88000	8/1/2018
ABC	ABC Product	Total Cost per unit	25	8/1/2018
ABC	ABC Product	Raw Material	15	8/1/2018
ABC	ABC Product	Other material & packout	10	8/1/2018

Thanks again.

Thomas

[lalphonso]

Hi Hin,

You will probably need to use the Generic Load statement first to "unpivot" your table on the "Label" field. Then you can use a straight formula to get the revenue.

The function is described here

The Generic Load

Regards

LA

[BalaBhaskar_Qlik]

Try something like this:

General:

....... // Initial table.

noconcatenate

ABC:

load ProductFamilyCode,

       Sum(If(Label = 'Selling Price', Price) * If(Label = 'Volume', Price)) as Value

Resident General

Group By ProductFamilyCode;