topic Re: Reference Line show in the top in QlikView

Reference Line show in the top

Wed, 04 Mar 2015 01:38:44 GMT

Hi all,

I use reference line my chart. But I could not make it to show the 100% value in the top of reference line. Could anyone tell me how to solve this problem?

Jelly

Re: Reference Line show in the top

JonnyPoole — Wed, 04 Mar 2015 02:22:59 GMT

Sure , make the static max value on the y axis equal to 110% or 1.1 for example. Then the reference line will always be visible and not hidden at the border.

Re: Reference Line show in the top

Wed, 04 Mar 2015 02:28:16 GMT

Hi Jonathan,

Thanks so much! The method you provided do work! And I also want to know whether there is another method? Since I looked other people's chart and the static max is 1 and also the reference line is 100, it also could work....

Thanks!

Jelly

Re: Reference Line show in the top

JonnyPoole — Wed, 04 Mar 2015 02:36:01 GMT

You could keep the max at 1 and then add a 'text in chart' on the presentation tab of 100%. Then hold down shift/ctrl keys at the same time, click the chart and you will see red lines appear around all the movable elements in the chart including the '100%' text in chart item. Just move that to wherever you want.

Re: Reference Line show in the top

Wed, 04 Mar 2015 02:42:42 GMT

Thanks so much!