topic Re: Percentage in Single line - Line chart in QlikView

Percentage in Single line - Line chart

sivarajs — Wed, 17 Feb 2016 10:27:11 GMT

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

Re: Percentage in Single line - Line chart

tresB — Wed, 17 Feb 2016 10:48:00 GMT

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

Re: Percentage in Single line - Line chart

Anonymous — Wed, 17 Feb 2016 11:08:22 GMT

What exactly you want?

Which two expression you have?

Re: Percentage in Single line - Line chart

stigchel — Wed, 17 Feb 2016 11:10:18 GMT

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)

[LabelExpression1]-[LabelExpression2]

Re: Percentage in Single line - Line chart

rubenmarin — Wed, 17 Feb 2016 11:31:33 GMT

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.

Re: Percentage in Single line - Line chart

sasikanth — Wed, 17 Feb 2016 11:56:53 GMT

hi,

Invisible check box may help you in expression tab

add your third expression and make it as invisible

Re: Percentage in Single line - Line chart

sivarajs — Wed, 17 Feb 2016 12:09:21 GMT

Thanks Ruben, that worked.