Multiple Field lookup

Wed, 15 Feb 2012 15:39:16 GMT

This should be easy, but for some reason I can't figure it out.

There is field called [FeeRange Text]

I have a straight table

For each company I need to know how many time the "Send Out" appears in the [FeeRange Text]

That was easy, done with a simple count.

Every time "Send Out" appears it will be associated with a unique LastName, FirstName

My next expression I need to know how many times "INP_IV" or "2INP_IV" or "TP_IV" or "2TP_IV" appears in [FeeRange Text]

It is possible that a person will have a record "INP_IV" and different record with the same person "TP_IV"

if a single person has a record with any of those statuses or if a person has mutiple records with these status I need a 1

matt_crowther — Wed, 15 Feb 2012 16:18:49 GMT

This may be over simplifying the situation but try:

=if(match([FeeRange Text],'INP_IV','2INP_IV','TP_IV','2TP_IV)>0,1,0)

If the text is within longer strings you'll need to split them out first perhaps with the substring() function.

Hope that helps,

Matt - Visual Analytics Ltd

topic Multiple Field lookup in QlikView