topic Re: Add fixed position comment to chart in QlikView

Add fixed position comment to chart

Tue, 02 Sep 2014 16:29:12 GMT

Is it possible to add a comment to a chart in a fixed position relative to the data?

For example in the chart below, i would like to add a comment between weeks 31/3 and 7/4 to explain the large change in numbers. However i would obviously require the comment to move along with the graph when the user scrolls.

Clearly just adding a text object would not work.

Re: Add fixed position comment to chart

JonnyPoole — Tue, 02 Sep 2014 19:22:49 GMT

Is this closer to what you want ?

Re: Add fixed position comment to chart

MarcoWedel — Tue, 02 Sep 2014 22:07:45 GMT

Hi,

another solution that might also help:

regards

Marco

Re: Add fixed position comment to chart

jagan — Wed, 03 Sep 2014 01:54:37 GMT

Hi,

Try like this

Chart Properties -> Presentation -> Text in Chart -> Add -> Give your text -> OK -> OK

Now click on chart and hold ctrl + shift buttons and move the label to required position in chart. Hope this helps you.

Regards,

Jagan.

Re: Add fixed position comment to chart

Wed, 03 Sep 2014 15:17:01 GMT

That method doesn't work, because the text does not move with the associated data.

If i use the x-axis scrollbar, the data move by the text stays still. I need the text to move with the data when the user uses the scrollbar

Re: Add fixed position comment to chart

Wed, 03 Sep 2014 15:29:28 GMT

Hi Jonathan,

this almost works. However, it makes the values on each bar data point turn into a dash. The bars themselves don't change, it's just they have a - above them now instead of a number.

I was able to get round this by clicking the 'text on axis' box, which end in the same end result.

Thanks for your help

Alex

Re: Add fixed position comment to chart

Wed, 03 Sep 2014 15:30:06 GMT

I am connecting directly to a database, so this isn't an option unfortunately.

Re: Re: Add fixed position comment to chart

MarcoWedel — Wed, 03 Sep 2014 15:53:06 GMT

the comment does not need to be loaded from a DB of course:

=If(Week='31/03/2014',Dual(value&chr(10)&'something really ugly happened', Num(value, '#,##0')),Num(value, '#,##0'))

as a front end expression delivers the same result:

hope this helps

regards

Marco