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: 
sivarajs
Specialist II
Specialist II

Percentage in Single line - Line chart

Hi,

I have a line chart with two expression. I need to calculate percentage and to show in single line. See the attached image.I tried by adding third expression and changed axes format. But my customer wants to be in single line. How to achieve it?.


Regards,

Siva raj

1 Solution

Accepted Solutions
rubenmarin

Hi Sivaraj, attached an example, I added a 3rd expression without with transparent line and text in data points, and used Dual to keep it 5% above the max value.

View solution in original post

6 Replies
tresesco
MVP
MVP

Could you share a sample qvw with sample data and explain the expected output?

Anonymous
Not applicable

What exactly you want?

Which two expression you have?

stigchel
Partner - Master
Partner - Master

If I assume you want to display the difference between the two expressions in a single line, then set the two expressions for 2014 and 2015 to invisible and add a third expression that is visible as line with an expression like

Column(1)-Column(2)

or

[LabelExpression1]-[LabelExpression2]

rubenmarin

Hi Sivaraj, attached an example, I added a 3rd expression without with transparent line and text in data points, and used Dual to keep it 5% above the max value.

sasikanth
Master
Master

hi,

Invisible check box may help you in expression tab

add your third expression and make it as invisible

sivarajs
Specialist II
Specialist II
Author

Thanks Ruben, that worked.