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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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

Labels (1)
1 Solution

Accepted Solutions
swuehl
Champion III
Champion III

Maybe like

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

as expression with dimension Month

View solution in original post

2 Replies
swuehl
Champion III
Champion III

Maybe like

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

as expression with dimension Month

sunny_talwar
MVP
MVP

May be like the attached

Capture.PNG