Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Comment/Note in the graph

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

13 Replies
Not applicable
Author

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,

KC

Not applicable
Author

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

rwunderlich

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

Not applicable
Author

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

Not applicable
Author

Hey Hi,

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

Regards,

KC

rwunderlich

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

-Rob

oscarmqz
Creator III
Creator III

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")

Capture.PNG

Capture.PNG

Not applicable
Author

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

Not applicable
Author

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