Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Regards
LA
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;