Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
ch_riadh
Partner - Creator II
Partner - Creator II

Like Function ?

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

6 Replies
tresesco
MVP
MVP

Try:

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

MK_QSL
MVP
MVP

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

anbu1984
Master III
Master III

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

Not applicable

try like this

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

anbu1984
Master III
Master III

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


Or


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

ch_riadh
Partner - Creator II
Partner - Creator II
Author

Thanks