Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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

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.