Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: 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

1 Solution

Accepted Solutions
daniel_kusiak
Creator II
Creator II

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

View solution in original post

19 Replies
sujeetsingh
Master III
Master III

Use Barr Offset to achieve this.

qlikviewwizard
Master II
Master II
Author

sujeetsingh,Could you attach the file, please .

smilingjohn
Specialist
Specialist

HI PLease find the attachment

qlikviewwizard
Master II
Master II
Author

smilingjohn

There is no attachment.

qlikviewwizard
Master II
Master II
Author

Hi smilingjohn,

My requirement is like this:

For eg:

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

Capture.JPG

MK_QSL
MVP
MVP

Check this..

qlikviewwizard
Master II
Master II
Author

Hi MRKachhiaIMP

Excellent. Many thanks.

svenkita
Creator II
Creator II

Attached is the solution

qlikviewwizard
Master II
Master II
Author

Any other solutions please.