Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: 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