bar colr has to dsplay in starigght table

[qlikapple]

Hi please find the below requirement

I have provided the sample data , actually the services are coming from database and they are  huge , we cannot hardcode everytime , is there any dynamice way to do

[Anil_Babu_Samineni]

Can you apply this for Service Background Color?

Color(FieldIndex('NO', NO))

[Muthu]

Are you expecting something like this?

You can use background color in expressions

[kaushiknsolanki]

Along with what loveisfail‌ said, check the "Persistence Colors" in both charts.

Regards,

Kaushik Solanki

[qlikapple]

as there are some thousads of services coming from the database and No( both columns  are coming from different tables) i just gave sample data. Everytime i cannot hardcode  to get the bar colrs (bar chart) in staright table. Is there any dynamic way .

[Anil_Babu_Samineni]

Looks your eyes working good, But i wonder, Straight table won't have feature called Color. And in Bar chart, I think persistence Colors won't work rather we will go Multicolored.

Correct me if i am wrong

[Anil_Babu_Samineni]

I am not sure, What do you mean dynamic. Here, You can use these settings for your bar chart (Please check the Multicolored and Persistence color options) where straight table use my statement where my first response

[qlikapple]

persistent colr wont work , but the user requirement is what ever the bar colr shows in the bar chart , the staright table has to show the same color .

[Anil_Babu_Samineni]

Strange, Why it's not working. It should work. May be helps to you

With out selection

With Selection

And settings set up

BG Color for expression

[kaushiknsolanki]

You are right,

Thanks for correcting me.

Although you missed to say that the expression you gave should work on both the chart expression.

I was trying one with multicolor option and other with expression.

Anyways thanks again.

Regards,

Kaushik Solanki