topic Re: Like Function ? in QlikView

Like Function ?

ch_riadh — Tue, 18 Nov 2014 07:35:00 GMT

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

I try this expression

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

but it s not working

tresB — Tue, 18 Nov 2014 07:36:06 GMT

Try:

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

MK_QSL — Tue, 18 Nov 2014 07:36:24 GMT

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

anbu1984 — Tue, 18 Nov 2014 07:36:58 GMT

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

Tue, 18 Nov 2014 07:38:10 GMT

try like this

aggr(if(name='A*')i,d)

anbu1984 — Tue, 18 Nov 2014 07:39:13 GMT

Count( if( Wildmatch(Name,'A*') , ID ))

Count( if( Left(Name,1) = 'A' , ID ))

ch_riadh — Tue, 18 Nov 2014 07:49:23 GMT

Thanks