Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
denis115
Creator
Creator

chart

Hello! I've got a problem. Can I show difference in percentage between two or more years in a histogram?

It must look like :

for example : Sales from 2015 are more than in 2014 by 50% but sales from 2016 are lower than in 2015 by 15%.

Can I do this with out entering in script? only by adding an expression in properties of chart? Please help me.

13 Replies
denis115
Creator
Creator
Author

my expression for calculating is      sum(SUMI)-sum(SUMRETURN)

tresesco
MVP
MVP

What if you have two more years say, 2017 and 2018? What would be your expected output then?

denis115
Creator
Creator
Author

what do you mean?

tresesco
MVP
MVP

Please, ignore my previous comment and try to share your sample qvw to work on.

denis115
Creator
Creator
Author

sample

tresesco
MVP
MVP

Which one is your year field?

denis115
Creator
Creator
Author

first one

denis115
Creator
Creator
Author

is there any question?

tresesco
MVP
MVP

Like this?

Capture.PNG