Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for
Search instead for
Did you mean:
Anonymous
Not applicable

## Compare YoY Sales in the same line graph

Hi everyone,

I want to see a simple line graph that shows a line for FY14 sales and a separate line for FY15 sales on the same line graph.  Data is ordered sequentially and example graph below.   I've read a few forums with very complicated suggestions for complicated datasets, but mine is simple - 2 cuts of the same dataset.    I assume I create an Expression with a formula  (e.g. Sales  where Year = 2014) and another Expression ( Sales  where Year = 2015), so what's the syntax to show only a limited selection of the same data ?

 Year Month Sales 2014 January 65% 2014 February 72% 2014 March 66% 2014 April 50% 2014 May 60% 2015 January 70% 2015 February 73% 2015 March 80% 2015 April 70% 2015 May 65%

And second question is - how do I then add a singular line that represents the target ?  So if Target is 80% across the year, can I do this another way that doesn't involve adding it line by line in to the source data ?

Thanks,

Dave

1 Solution

Accepted Solutions
Not applicable
Author

Hi,

In the expression use this formula

=sum({<Year={'2014'}>}Sales)  for the YOY for 2014

=sum({<Year={'2015'}>}Sales) for YOY for 2015

5 Replies
Not applicable
Author

Hi,

In the expression use this formula

=sum({<Year={'2014'}>}Sales)  for the YOY for 2014

=sum({<Year={'2015'}>}Sales) for YOY for 2015

Master III

try

sum({<Year={2015}>} Sales)

sum({<Year={2014}>} Sales)

Specialist III

create a variable lik

vYear= max(Year)-1

then create a input box with variable vYear

create chart with expressions

sum({\$<Year={\$(=Max(Year))}>} Sales)

sum({\$<Year={\$(=Max(Year)-vYear)}>} Sales)

you can compare 2015 with 2014 and also with more previous years by changing values in input box

Anonymous
Not applicable
Author

Thanks everyone - I especially like the input box variable idea.

I've also just worked out how simple my second question is to answer 🙂

A third Expression with =80%

Anonymous
Not applicable
Author

For your second question, you could also just add a Reference Line on the bottom right of the Presentation tab.

Community Browser