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.

[sujeetsingh]

Use Barr Offset to achieve this.

[qlikviewwizard]

sujeetsingh,Could you attach the file, please .

[smilingjohn]

HI PLease find the attachment

[qlikviewwizard]

smilingjohn

There is no attachment.

[qlikviewwizard]

Hi smilingjohn,

My requirement is like this:

For eg:

I want to show JOB ANALYST 33.33% as hwon below screen.

[MK_QSL]

Check this..

[qlikviewwizard]

Hi MRKachhiaIMP

Excellent. Many thanks.

[svenkita]

Attached is the solution

[qlikviewwizard]

Any other solutions please.