This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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?