topic Re: How to set multiple colors in bar chart dimension text? in QlikView

How to set multiple colors in bar chart dimension text?

woshua5550 — Wed, 25 Nov 2020 16:16:04 GMT

hi all

for example

"Beijing" shown as red

"Shanghai" shown as black

thanks

oknotsen — Wed, 22 Jun 2016 06:40:28 GMT

Go to the Colors tab and near the top right corner select "Multicolored".

Anonymous — Wed, 22 Jun 2016 06:57:10 GMT

Frank_Hartmann — Wed, 22 Jun 2016 07:07:17 GMT

Try like this:

Add expression:

if(city='Beijing',red(),if(city='Shanghai',black(),'othercolour'))

woshua5550 — Wed, 22 Jun 2016 07:20:12 GMT

thanks for your reply , but i don't think it works , i need to change the color of label rather than the bar

woshua5550 — Wed, 22 Jun 2016 07:25:05 GMT

yes i supposed it will work but it not , i have tried but nothing happened, does it works for you ?

if so ,can you attech your test file ? thanks

Frank_Hartmann — Wed, 22 Jun 2016 09:21:59 GMT

Have a look at this post:

sampada0810 — Wed, 22 Jun 2016 10:25:00 GMT

Go to colors tab in the chart properties and check the Multicolored checkbox

beck_bakytbek — Wed, 22 Jun 2016 12:35:08 GMT

Hi Lau,

try to make those steps:

1.tab: Expression >Select your Expression > BackgroundColor

2. type this this Expression: if(City='Beijing',Red())

i hope that helps

beck

woshua5550 — Wed, 22 Jun 2016 13:17:52 GMT

Hi beck

maybe i didn't state clearly

i want to change the color of dimension axis lable

thanks