Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Honored Contributor 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
Highlighted
Contributor II

Re: Showing the percentage difference

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

View solution in original post

19 Replies
Highlighted
Honored Contributor III

Re: Showing the percentage difference

Use Barr Offset to achieve this.

Highlighted
Honored Contributor II

Re: Showing the percentage difference

sujeetsingh,Could you attach the file, please .

Highlighted
Contributor III

Re: Showing the percentage difference

HI PLease find the attachment

Highlighted
Honored Contributor II

Re: Showing the percentage difference

smilingjohn

There is no attachment.

Highlighted
Honored Contributor II

Re: Showing the percentage difference

Hi smilingjohn,

My requirement is like this:

For eg:

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

Capture.JPG

Highlighted
MVP
MVP

Re: Showing the percentage difference

Check this..

Highlighted
Honored Contributor II

Re: Showing the percentage difference

Hi MRKachhiaIMP

Excellent. Many thanks.

Highlighted
Contributor II

Re: Showing the percentage difference

Attached is the solution

Highlighted
Honored Contributor II

Re: Showing the percentage difference

Any other solutions please.