Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
neetu_singh
Partner - Creator III
Partner - Creator III

Need Help - For dynamically changing color of text on right-side of bars

Dear All,

Actually I need dynamically changing color of text on right-side of bar charts(highlighted below) for negative (RED) & Positive (GREEN) numbers but it is not working due to second dimension

Please help.

test.jpg

1 Solution

Accepted Solutions
Not applicable

Neetu,

You should format 'Non - Commissionable 1'. Please see attached qvw.

Hope it help.

Thanks.

View solution in original post

15 Replies
arulsettu
Master III
Master III

post sample qvw of this chart

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

You can use the Text Color setting of the expression:

comm192067.png


talk is cheap, supply exceeds demand
neetu_singh
Partner - Creator III
Partner - Creator III
Author

Yeah am doing the same but in my application we are using 2 dimension so because of second dimension it is not changing.

nagarjuna_kotha
Partner - Specialist II
Partner - Specialist II

PFA....

nagarjuna_kotha
Partner - Specialist II
Partner - Specialist II

Hi neetu,

I want to know one thing in your chart.

How you did Both negative and Positive values on same line.

Can u tell the procedure.

Regards,

Nagarjuna

Mark_Little
Luminary
Luminary

Hi,

Follow gwassenaar instructions, but in your expression just have the expression you want to impact the colour. So the one in the brackets.

Mark

neetu_singh
Partner - Creator III
Partner - Creator III
Author

Text color property is not working in my scenario. I'm taking this value as an text not in bar presentation, please chk the attached image.

nagarjuna_kotha
Partner - Specialist II
Partner - Specialist II

Check this ,I tried in Text Box.To check this.Sect negative value in list box and the color in Text Box.

Reagrds,

Nagarjuna

neetu_singh
Partner - Creator III
Partner - Creator III
Author

The scenario is am using this expression as a text nd bar is invisible. this is the reason that color is not changing. can you please share if there is any work around for the same.