topic Re: Draw a reference line at 90 % in Bar chart in QlikView

Draw a reference line at 90 % in Bar chart

markgraham123 — Wed, 15 Jul 2015 20:10:34 GMT

Hi Everyone,

I have a bar chart which shows the percentages of specified names.

I wanna draw a reference line at 90 %.

I tried out Presentation> Reference> add> Expression....

but no luck..

Can anyone look into this.

dionverbeke — Wed, 15 Jul 2015 20:13:24 GMT

Hi,

Select Combo Chart and add a 0.90 line chart expression and label it 90%.

You can do the same with the refence expression: 90% as label and 0.9 as expression.

Usually it goes wrong because you forgot to set it on the secondary axis because it is a percentage xpression.

Dion

Nicole-Smith — Wed, 15 Jul 2015 20:17:59 GMT

markgraham123 — Wed, 15 Jul 2015 20:18:34 GMT

Hi Dion,

Its working. But as u said, its not working with Secondary axis selcted, its working with primary axis.

markgraham123 — Wed, 15 Jul 2015 20:19:13 GMT

Thanq verymuch Dion,

It sworking.

markgraham123 — Wed, 15 Jul 2015 20:19:55 GMT

Thanq very much Nicole Smith

vikasmahajan — Thu, 04 Aug 2016 06:56:36 GMT

How to apply the same in Qlik Sense ?

Vikas