Multiple Field lookup - Qlik Community

Report Inappropriate Content · ‎2012-02-15

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 · ‎2012-02-15

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