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

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
anuradhaa
Partner - Creator II
Partner - Creator II

Show difference in line chart

I have below data set. I want to calculate the differance and show that in line chart

My Data set as follow

  

MonthSales
2014-dec1000
2015-jan1500
2015-feb2000
2015-march750
2015-april1586
2015-may2258
2015-june4415
2015-july2133
2015-aug9946
2015-sep1334
2015-oct1587
2015-now2145
2015-dec987
2016-jan

2456

I want to show

  

jan-dec500
Jan - feb500
feb -march-1250
march - apr836
apr -may672
may -june2157

etc in line chart. for last 12 months

is it possible

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Maybe like

=Sum(Sales) -Above(Sum(Sales))

as expression with dimension Month

View solution in original post

2 Replies
swuehl
MVP
MVP

Maybe like

=Sum(Sales) -Above(Sum(Sales))

as expression with dimension Month

sunny_talwar

May be like the attached

Capture.PNG