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

Announcements
April 13–15 - Dare to Unleash a New Professional You at Qlik Connect 2026: Register Now!
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)

tresB
Champion III
Champion III

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?

tresB
Champion III
Champion III

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

denis115
Creator
Creator
Author

sample

tresB
Champion III
Champion III

Which one is your year field?

denis115
Creator
Creator
Author

first one

denis115
Creator
Creator
Author

is there any question?

tresB
Champion III
Champion III

Like this?

Capture.PNG