topic Re: Comment/Note in the graph in QlikView

Comment/Note in the graph

Tue, 03 Nov 2015 02:11:19 GMT

Hai All,

I am Yayat,

now i am working at 1 of automotif manufacture company,

I have a plant to make problem report by graph (as visualization) and several commnet/note for additional information. so our management can easily read-analyse-make decission from those report.

off course this comment/note is maintain in database, means they input this comment in database.

unfortunatelly, until know we still don't find any way how to put some comment/note at graph in click view.

attached is ilustrate graphic with commnet/note,

if you know or have any idea, kindly please share with us

Thank you

Re: Comment/Note in the graph

Tue, 03 Nov 2015 05:00:51 GMT

Hi,

Option 1:

You can use a text object and place it on the chart. Use option Layer option under Layout with top = 1 and make transparency color = 100%

Option 2:

Use a "Text in chart option" under presentation tab of the chart. You can customize it according to your wish.

I would recommend you to use option 2, its easy and straight forward.

Thanks,

Re: Comment/Note in the graph

Tue, 03 Nov 2015 05:42:07 GMT

Thank you for your idea,

regarding option no 2,

could we put more than 1 chart text in same position?

as I try, when we create more than 1, the position all of them will be replaced

please advice me

thank you

Re: Comment/Note in the graph

rwunderlich — Tue, 03 Nov 2015 06:15:06 GMT

Have a look at this example to see if if gives you any ideas.

Qlikview Cookbook: Tutorial - Annotating Chart Data Points http://qlikviewcookbook.com/recipes/download-info/tutorial-annotating-chart-data-points/

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Re: Comment/Note in the graph

Tue, 03 Nov 2015 06:51:05 GMT

Thanks Mr. Rob,

unfortunatelly my Qlickview is free version, means can't open other *.qvw file,

but as glance, it will be helpfull for me if i can use it.

could you please give me print screen or something to explain more?

thank you

Re: Comment/Note in the graph

Tue, 03 Nov 2015 10:30:00 GMT

Hey Hi,

You can add as many texts you want. Press Control + Shift and move the box wherever you want.

Regards,

Re: Comment/Note in the graph

rwunderlich — Tue, 03 Nov 2015 14:23:35 GMT

You should be able to open that example with Personal Edition.

-Rob

Re: Comment/Note in the graph

Anonymous — Tue, 03 Nov 2015 15:17:26 GMT

Hi Yayat, use DUAL function to read the comment from database, duplicate your expression, enable data points for the dual expression and set same color... see image below you can see the expression definition in the legend, let me know if questions. (TEST is my field name where I inserted comments "Oscar" and "Márquez")

Re: Comment/Note in the graph

Wed, 04 Nov 2015 05:52:18 GMT

Hai Mr. Cho,

Thank you for your advice,

now the text can be moved (thank for that), i have little bit question:

1. Are this text only can add during design, aren't?

2. is it possible connect to database? means text that we mention refere to database.

Thank you for your information

Re: Comment/Note in the graph

Wed, 04 Nov 2015 06:09:45 GMT

Hi Mr. Oscar,

as I understand, it will work when the comment rule in max/min condition,

back to my case, in example there are plan and actual budget,

the acceptable condition are :

1. Plan=Actual

2. Plan>Actual, because of some efficiency activity (must put some comment)

the in-acceptable condition are:

1. Plan<Actual, means over budget (must put some comment)

2. Plan>Actual, means some budget not use, may be several project is pending/delay (must put the comment)

if so, we can said the comment rule are random depend on graph creator.

Please advice me,

Thank you

Re: Comment/Note in the graph

Wed, 04 Nov 2015 10:50:27 GMT

Hey,

Yes, you can add this text at design phase, place where you want to show and make it dynamic as well.

You can connect the text field to database, as it is some value in database and you can show it.

Regards,

Re: Comment/Note in the graph

Fri, 06 Nov 2015 00:14:07 GMT

Hai Mr. Cho,

now my comment showed from database, its make me more insterest, thank very much.

but I still have issue, hopefully you can solve it,

when I wan to put 2 comment, they alwas show same value, but in expected its should be showed different value, for example at the graph showed january 1, and january 2, both of them have different comment as record in database,

january 1 comments = "Unstable dollars"

january 2 comments = "project delay"

could you give me some advice about that,

Thank you

Re: Comment/Note in the graph

Anonymous — Fri, 06 Nov 2015 14:10:51 GMT

Hi Yayat,

I still believe you can use what I suggested, I'd like to have a copy of your document to take a look and understand a bit more how your comments are loaded into your database, are they tied to a date? If you can please share your file.

Using static textboxes added in design mode may not be the best, unless you control how many data point will be displayed in chart, there's no presice way to control the position of them respect the chart.

Regards,

Re: Comment/Note in the graph

Bonnie — Wed, 05 Dec 2018 17:42:22 GMT

Select the chart/graph and click CTRL+SHIFT. This will allow you to separate lines of text and to arrange each line of text