topic write an expression -like in QlikView

write an expression -like

Anonymous — Sun, 30 Aug 2015 10:03:22 GMT

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 .

Re: write an expression -like

sunny_talwar — Sun, 30 Aug 2015 10:05:52 GMT

May be this:

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

Re: write an expression -like

Anonymous — Mon, 31 Aug 2015 03:55:52 GMT

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))

Re: write an expression -like

Anonymous — Mon, 31 Aug 2015 03:57:03 GMT

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

Re: write an expression -like

jagan — Mon, 31 Aug 2015 04:13:40 GMT

Hi,

Try like this using set analysis

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

Hope this helps you.

Regards,

jagan.

Re: write an expression -like

Mon, 31 Aug 2015 05:29:06 GMT

Hi,

Try this one:

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

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

Re: write an expression -like

qlikviewwizard — Mon, 31 Aug 2015 07:16:06 GMT

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.