Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Background Colour

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

Tags (1)
7 Replies

Re: Background Colour

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

MVP
MVP

Re: Background Colour

Hi,

Try like this using MixMatch like below

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

Not applicable

Re: Background Colour

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.

Re: Background Colour

Hi,

Can you upload screenshot of the table you have created.

Regards,

Kaushik Solanki

Not applicable

Re: Background Colour

Hi Pramod,

Try this out

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

Regards,

Rohan

Re: Background Colour

Try this way

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

Regards

Anand

Community Browser