write an expression -like

[Anonymous]

I am looking to write an expression in order to calculate the number of OwnerID where [Working Status] is LIKE  'Employee

=count ({<[Working Status] = {'Employee'}>} Distinct OwnerID)

How to add LIKE in the expression above ? Any help would be the most appreciated .

[sunny_talwar · Accepted solution]

May be this:

=Count({<[Working Status] = {'*Employee*'}>} Distinct OwnerID)

[Anonymous]

Like is used in IF statements. I think set analysis does not like "Like" in its expression. but Sunny has suggested what might just be the one you r looking for. if you want to include Like, the following should work:

=count(Distinct if( [Working status] Like '*Employee*', Distinct OwnerID))

[Anonymous]

This one:      =count(Distinct if( [Working Status] Like '*Employee*', OwnerID))

[jagan]

Hi,

Try like this using set analysis

=count ({<[Working Status] = {'*Employee*'}>} Distinct OwnerID)

Hope this helps you.

Regards,

jagan.

[#6]

Hi,

Try this one:

=COUNT ({<[Working Status] = {"Employee*"}>} DISTINCT OwnerID)

=COUNT ({<[Working Status] = {"*Employee*"}>} DISTINCT OwnerID)

[qlikviewwizard]

Hi,

Please use the below expression:

'*' will be used for searching the data with values Employee.

=count ({<[Working Status] = {'*Employee*'}>} Distinct OwnerID)

Please check the attached file for the sample file.