Showing the percentage difference

[qlikviewwizard]

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.

Year	JOB	2014	2015	SAL %
2014	ANALYST	6000	4500	33.33
2014	CLERK	3950	4150	-4.82
2014	MANAGER	11275	7275	54.98
2014	PRESIDENT	6000	5000	20.00
2014	SALESMAN	8300	5600	48.21

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

[#2]

[daniel_kusiak · Accepted solution]

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

[qlikmsg4u]

See attached file

[qlikviewwizard]

Hi Daniel_Kusiak

Thank you for the reply.

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

[daniel_kusiak]

For me it looks like that.

[qlikviewwizard]

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

[daniel_kusiak]

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

[qlikviewwizard]

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]

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

[qlikviewwizard]

Thank you all for wonderful answers.