Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
fcecconi
Partner - Creator III
Partner - Creator III

can this be done?

I need to change the background color of field in a straight table based on a value that is not being included in the straight table.  For example, I want to change the background color of the user name who ever worked in Pennsylvania.  However the state names are NOT being displayed in the table.  Only the user name and a series of measures.

Name# of Calls# of Days Worked# of Complaints
Steve5032
Frank60410
Tom4040
Beth75315

Tom worked in Pennsylvania.

Thanks in advance for your help!

1 Solution

Accepted Solutions
prieper
Master II
Master II

Hi Frank,

should work with a construction to concatenate all states and check any match.

as aircode:

IF(WILDMATCH(CONCATENATE(State, '|'), 'Texas'), LIGHTRED())

Peter

View solution in original post

6 Replies
prieper
Master II
Master II

Why not?

See the attached file

HTH Peter

maxgro
MVP
MVP

try with

if(count({$ <state={Pennsylvania}>} state)>0,red())

fred_s
Partner - Creator III
Partner - Creator III

In addition to Peter and Massimo...

Grtz. Fred

textcolor.JPG

fcecconi
Partner - Creator III
Partner - Creator III
Author

Peter

This works fine if a person only has 1 state.  But my data has multiple states for each person.  How can I find PA in the list of all the states that a name has?

thanks


prieper
Master II
Master II

Hi Frank,

should work with a construction to concatenate all states and check any match.

as aircode:

IF(WILDMATCH(CONCATENATE(State, '|'), 'Texas'), LIGHTRED())

Peter

fcecconi
Partner - Creator III
Partner - Creator III
Author

Peter

thanks.  I was able to get it to work!