Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi There,
I am working on a project in Qlik Sense and I desperately need help.
I have a 3 Tables in Excel
Table 1: is pricing for FinYear 2016
Brand , 1kg , 2kg, 500kg, 1000kg
Brand1, 50, 100, 200, 500
Brand2, 60, 50, 600, 800
Table2: is pricing for FinYear 2017
Brand , 1kg , 2kg, 500kg, 1000kg
Brand1, 60, 200, 400, 600
Brand2, 60, 80, 700, 900
Table3 : Sales Quantities
Brand, Qty, PackSize, Date
Brand1, 500, 1kg, Aug-2015
Brand2,400, 2kg, Apr-2015...
Also the Financial Year runs Jul-Jun
How do I associate the tables to get the sales revenue for each financial year using the right price for the right brand and the right Pack Size?