Background Colour

[#1]

Hi all,

I am trying to add a background color for a column in a table.

i have used : if(Metrics='Emails Delivered (total)', RGB(239,239,176))

This will add color for one field i need to add for entire column, which expression should i use.

I am adding color like :

if(Metrics='Emails Delivered (total)', RGB(239,239,176),

if(Metrics='List Size', RGB(239,239,176),

if(Metrics='Unique Opens (total)', RGB(239,239,176))))

I have 10 rows i need to add 10 line, instead any other expression which can apply color to whole column.

Regards,

Pramod

[Anonymous]

might be helpful for you?

Qlik sense straight table measure color expression

Background Colors based on condition in tables in Qlik Sense

https://help.qlik.com/sense/1.0/en-us/online/Subsystems/WorkingWith/Content/Colors/ColorByExpression...

Qlik sense straight table dimension color expression

[kaushiknsolanki]

Hi,

If you need colors for each of the expression in "QlikView" then its simple.

Go to Properties of the chart -> Expression Tab -> Click on + sign before Expression Label -> set the background color.

Do this for each expression and you are done.

Regards,

Kaushik Solanki

[jagan]

Hi,

Try like this using MixMatch like below

if(MixMatch(Metrics, 'Emails Delivered (total)',  'List Size', 'Unique Opens (total)', RGB(239,239,176))

[#5]

Hi Jagan,

Thanks for the reply,

You have missed the braces i have added, but still i am getting error in expression.

if(MixMatch(Metrics, 'Emails Delivered (total)',  'List Size', 'Unique Opens (total)', RGB(239,239,176)))

Help on it.

[kaushiknsolanki]

Hi,

Can you upload screenshot of the table you have created.

Regards,

Kaushik Solanki

[#7]

Hi Pramod,

Try this out

if(Match(Metrics, 'Emails Delivered (total)',  'List Size', 'Unique Opens (total)'),RGB(239,239,176))

Regards,

Rohan

[its_anandrjs]

Try this way

if( Match(Metrics, 'Emails Delivered (total)' , 'List Size' , 'Unique Opens (total)' ) = 1 , RGB(239,239,176) )

Regards

Anand