Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ 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

5 Replies
Arthur_Fong
Partner
Partner

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
Partner

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
Support (Former)
Support (Former)

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.