Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
BIDev
Creator
Creator

RGB Based on the value.

Hi,

I have data a below.

StateMetroCityAddress
ColoradoDenverDenver123 ABC street
ColoradoLittletonGolden134 ABC street
ColoradoDenverLittle100 ABC street
ColoradoLittletonGolden111 ABC street

 

Can I set the background color of Address column to change based on the selection.

Ex:If I pick Littleton, I want 134 ABC and 111 ABC street bkgrd to be green and the rest of the address go blue.

Thank you

 

1 Solution

Accepted Solutions
StarinieriG
Partner
Partner

Hi,

try to see file attached

View solution in original post

3 Replies
mfarsln
Creator II
Creator II

Hi,

You can try something like below expression for Address column's background color expression.

if(
GetFieldSelections(Metro,',') = 'Littleton',green(), blue()
)

 

StarinieriG
Partner
Partner

Hi,

try to see file attached

View solution in original post

BIDev
Creator
Creator
Author

Works like a charm.TY much.