YoY Change in Volume ( CY-LY) - Qlik Community

vikasmahajan · ‎2018-01-28

Hi all,

I wanted to create a line chart Company/Product Wise yearly (YoY) change in volume (CY-LY) for all the years.

Company1

Company 2 Line Chart with Volume(CY-LY)

2013 2012 2011 2010 2009 2008

How to create in Qlik Sense ? I have attached QVF and Sales Data Sample.

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

Anonymous · ‎2018-01-28

Using the Above() like this

Sum(SalesVol) * above ( Sum(SalesVol) )

You could do something like the attached.