Like function

[ch_riadh]

How can i Count ID if the NAME start with 'A'.

I try this expression

Count(  if  (Like (Name = 'A*') , ID )

but it s not working

[MK_QSL]

Like Function ?

Count(IF(Name Like 'A*',ID))

or

Count({<Name = {'A*'}>}ID)

or

COUNT(If(WildMatch(Name,'A*'),ID))

or

In your script, create a field as IDFlag just below the Name Field

If(Name Like 'A*',1,0) as IDFlag

Now You can use as below

SUM({<IDFlag = {1}>}IDFlag)

[ashfaq_haseeb]

Hi,

Check this

Count({<Name={'A*'}>} ID)

Please do not create multiple threads.

Its answered here.

http://community.qlik.com/thread/142544

Regards

ASHFAQ