Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

bhavvibudagam
Contributor II

Straight Table color Formatting

Hi Experts,

Can any one please help me on below requirement.

In the below Straight table, I have to seperate PAID MEDIA and ORGANIC MEDIA related rows with Green and Cream colors.

By harcoding Media type and Media records I have seperated with two colors.

But how to separate PAID Media and ORGANIC MEDIA related Visits ,Visit Goal,%Goal and Orders Placed values with Green and Cream colors means First 4 rows in Green color and next 7 rows in Cream Color.

Here we cant hardcoded the number of visits because by filtering the Month Field these values will be changed.

Please help me on this. Please find the attached app.

Marketing.png

Thanks in advance.

1 Solution

Accepted Solutions
siddharth_s3
Contributor

Re: Straight Table color Formatting

Oh you work too hard.

Just put this in the measure background color; This should do your trick

if([Media Type]='PAID MEDIA',RGB(190,235,250),RGB(219,247,185))

1 Reply
siddharth_s3
Contributor

Re: Straight Table color Formatting

Oh you work too hard.

Just put this in the measure background color; This should do your trick

if([Media Type]='PAID MEDIA',RGB(190,235,250),RGB(219,247,185))

Community Browser