Discussion board where members can get started with Qlik Sense.
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.
Thanks in advance.
Go to Solution.
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))