Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Lily
New Contributor

Compare current and previous value

Hi All, 

I have requirement to create a chart that compare the value of product price. When filtering by Product, the chart will display the product price based on current and previous purchase of product by date. For example, in Jan 2019 we purchased the product but for the next 3 months we may not purchase it. So, user want to compare the current and previous product purchase as per chart below: 

chart.png

Purchase DatePurchase No.Price
2019012810001161
2018081510001140
2019050910002200

 

Can anybody help? 

Thank you.