Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
paul_ripley
Creator III
Creator III

Changing the colour of label of reference lines on a graph

Hello

I have a graph with a Max and Min reference line.  I can see how that it is possible to change the colour of the lines in the line formatting.  This also changes the Label to being the colour of the line.  If I wanted the Label text to be white  in Min and Max be white how can i do this.  I am not sure of the what i need to write in the expression box

Many thanks

Paul

Labels (4)
5 Replies
Arthur_Fong
Partner - Specialist III
Partner - Specialist III

If it is a static reference line, add using text in chart option:

MC.PNG

In chart properties > Presentation > text in chart > add text> Font >change color.

 

paul_ripley
Creator III
Creator III
Author

Hi

That changes the Text in the chart but not the Reference Lines.  The reference lines (Label) dont have the option to change font text

 
 

I cant see how to screenshot into Chrome to show the screen so i have attached a screenshot

Arthur_Fong
Partner - Specialist III
Partner - Specialist III

Refer to my screenshot above, is that what you are looking for?

I don't think it is possible to change label color, so I did a workaround by adding chart as text.

Changing the text(Target) into different colors (In the sample, I changed it to blue).

paul_ripley
Creator III
Creator III
Author

Hi Arthur
Thanks for trying but that wont work unfortunately as Max and Min will change depending on the monthly expenses. Its not static
Brett_Bleess
Employee
Employee

Hey Paul, here is the Help link on Reference Lines, and I think you were on the right track with using the expression in the label to do things, but I too am not quite sure, but I would think wrapping color function around the text you want to display would be the way to do it, I just do not know if that is possible! 🙂

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Reference_Lines...

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/ChartFunctions/...

I think you want something like White(YourLabelText), hopefully that may work.

Cheers,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.