topic Count using if statement in QlikView

Count using if statement

Anonymous — Thu, 15 Oct 2015 21:37:14 GMT

How can I count words which have the same first three characters (e.g. in SQL "abc%" )
using if statement maybe!

Thu, 15 Oct 2015 21:50:09 GMT

Count(Distinct Left(FIELD,3))

Anonymous — Thu, 15 Oct 2015 22:49:02 GMT

like this

if(left(Field,3)='abc',count(field))

sunny_talwar — Thu, 15 Oct 2015 23:53:12 GMT

Or may be this:

Count({<Field = {'abc*'}>} Field)

Anonymous — Fri, 16 Oct 2015 05:39:27 GMT

Hi Mohammed,

IF(Wildmatch(Field,'abc*'),Count(Field))

sujeetsingh — Fri, 16 Oct 2015 06:04:19 GMT

sunindia‌ has given the best performing expression.

Anonymous — Fri, 16 Oct 2015 12:24:24 GMT

thanks a lot it's working

Anonymous — Fri, 16 Oct 2015 15:51:08 GMT

you welcome

Regards!

Anonymous — Fri, 16 Oct 2015 15:55:13 GMT

if you find the right answer could close the thread please

Regards.

Anonymous — Sat, 17 Oct 2015 19:22:06 GMT

from where i can close the threat i don't know how.

Best Regards.