Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Qlikview Design Blog: http://QVDesign.wordpress.com