Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
vikasmahajan
MVP
MVP
‎2018-01-28 06:22 AM

YoY Change in Volume ( CY-LY)

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.
Change-YoY.qvf
Sales Change Example.xlsx
1,107 Views
0 Likes
1 Reply
Anonymous
Not applicable
‎2018-01-28 12:57 PM

Using the Above() like this

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


You could do something like the attached.

Change-YoY.qvf
925 Views
0 Likes