topic Re: Expression in QlikView

Expression

Anonymous — Thu, 05 Oct 2017 03:19:06 GMT

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

Re: Expression

rwunderlich — Thu, 05 Oct 2017 03:42:33 GMT

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

Re: Expression

techvarun — Thu, 05 Oct 2017 04:55:56 GMT

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

Re: Expression

Anonymous — Thu, 05 Oct 2017 14:23:32 GMT

Thanks Guys!