Discussion board where members can get started with QlikView.
I have the following data: 6 products from 2 brands and price during 6 days period:
i will have differences day by day (2-Dec vs 1-Dec, 3-Dec vs 2-Dec):
when the product has no price in 2 consecutive days, the differences will be 0 (e.g. product ID 6 on 2-Dec vs 1-Dec)
and then i want to calculate for the 2 brands the price variations between days:
the formula for the last table will be:
By Brand: Sum of differences 2-Dec (from second table)/ Sum of prices 1-Dec (from first table)
but only for products that have positive values on 2 consecutive days (1-Dec and 2-Dec)
I attached the Excel file with an easy understand of what i want.
How to do this in Qlik?
any help, guys?