Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikviewwizard
Master II
Master II

Showing the percentage difference

Hi All,

How to achieve the ((2014 SAL-2015 SAL)/2014 SAL)*100 for each JOB as shown in table and graph.

Thanks in advance.

  

YearJOB20142015SAL %
2014ANALYST6000450033.33
2014CLERK39504150-4.82
2014MANAGER11275727554.98
2014PRESIDENT6000500020.00
2014SALESMAN8300560048.21

How to show as shown the graph. Please find the attached application.

Capture.JPG

19 Replies
Not applicable

daniel_kusiak
Creator II
Creator II

A small modification to Manish file. Still, not exactly as you wanted.

qlikmsg4u
Specialist
Specialist

See attached file

qlikviewwizard
Master II
Master II
Author

Hi Daniel_Kusiak

Thank you for the reply.

I am getting the output like this.  Please help for the attached files.

Capture.JPG

daniel_kusiak
Creator II
Creator II

For me it looks like that.

qlikviewwizard
Master II
Master II
Author

FOr me 3rd one is not showing. What may be the reason? Am I missing something?

daniel_kusiak
Creator II
Creator II

You didn't set the Bar Offset. Look at the attached file now.

qlikviewwizard
Master II
Master II
Author

Hi Daniel_Kusiak,

Very strange. I have done the same but not succeeded.

Could you tell me which option/settings need to do?

daniel_kusiak
Creator II
Creator II

As I said before you didn't set the Bar Offset.

qlikviewwizard
Master II
Master II
Author

Thank you all for wonderful answers.