Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT 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 - Specialist
Partner - Specialist

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!