Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
fanko1225
Creator
Creator

Expression

Hi All,

I need a function to find certain text within the field. Let say I want to do a count base on field 1 and field 2 where string have the text "MANAGMENT" and "MGMT". It's not LEFT, RIGHT , or MID.

=Count({<{Field 1=, Field 2=}>}[Amount])

Field 1 ="489671467 TXYZ MANAGEMENT Inc"

Field 2 = "123567871467 WMZ MGMT Inc"

Many Thanks,

Frank

1 Solution

Accepted Solutions
techvarun
Specialist II
Specialist II

     Count({<Field1 = {"*MANAGEMENT*"},Field2 = {"*MGMT*"} >}Amount)

View solution in original post

3 Replies
rwunderlich

=Count({<{Field 1={"*MANAGEMENT*"}, Field 2={"*MGMT*"}}>}[Amount])

techvarun
Specialist II
Specialist II

     Count({<Field1 = {"*MANAGEMENT*"},Field2 = {"*MGMT*"} >}Amount)

View solution in original post

fanko1225
Creator
Creator
Author

Thanks Guys!