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

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
jacek_k
Contributor III
Contributor III

Previous year on line chart

Hi, 

SampleTable:

Load * Inline [
DATE,VALUE
'1.02.2019',7000
'2.02.2019',10000
'3.02.2019',3000
'1.02.2018',2000
'2.02.2018',15000
'3.02.2018',3500
];

Measure:

sum(value)

Dimension:

Date Start from 01.2019

I have a line chart showing simple sum value and I would like to add second line previus year. 

1.2019 value 100 - second line: 1.2018 value 50
2.2019 value 200 - second line: 2.2018 value 60 
etc

 

jacek_k_0-1614810017505.png

 

Labels (2)
0 Replies