Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
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?

balrajahlawat
Champion
Champion

What exactly you want?

Which two expression you have?

stigchel
Partner
Partner

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.

View solution in original post

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.