Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
New Contributor II

Price variations by aggregation

Hello all,

I have the following data: 6 products from 2 brands and price during 6 days period:

BrandProduct ID1-Dec2-Dec3-Dec4-Dec5-Dec6-Dec


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)

BrandProduct ID1-Dec2-Dec3-Dec4-Dec5-Dec6-Dec
A1 000100
A2 00000
A3 -1502000
A4 00000
B5 000-100
B6 00-1000


and then i want to calculate for the 2 brands the price variations between days:

Brand 1-Dec2-Dec3-Dec4-Dec5-Dec6-Dec
A  -14%0%33%10%0%
B  0%0%-7%-8%0%


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?


Thank you,


1 Reply
New Contributor II

Re: Price variations by aggregation

any help, guys?

Community Browser