topic Re: can this be done? in QlikView

can this be done?

fcecconi — Tue, 17 Mar 2015 20:55:30 GMT

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
Steve	50	3	2
Frank	60	4	10
Tom	40	4	0
Beth	75	3	15

Tom worked in Pennsylvania.

Thanks in advance for your help!

Re: can this be done?

prieper — Tue, 17 Mar 2015 21:04:52 GMT

Why not?

See the attached file

HTH Peter

Re: can this be done?

maxgro — Tue, 17 Mar 2015 21:04:55 GMT

try with

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

Re: can this be done?

fred_s — Tue, 17 Mar 2015 21:53:25 GMT

In addition to Peter and Massimo...

Grtz. Fred

Re: can this be done?

fcecconi — Wed, 18 Mar 2015 13:20:09 GMT

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

Re: can this be done?

prieper — Wed, 18 Mar 2015 13:39:59 GMT

Hi Frank,

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

as aircode:

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

Peter

Re: can this be done?

fcecconi — Wed, 18 Mar 2015 14:09:02 GMT

Peter

thanks. I was able to get it to work!