topic Like function in QlikView

Like function

ch_riadh — Tue, 18 Nov 2014 07:43:57 GMT

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 — Tue, 18 Nov 2014 07:52:58 GMT

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

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

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

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 — Tue, 18 Nov 2014 07:53:47 GMT

Hi,

Check this

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

Please do not create multiple threads.

Its answered here.

Regards

ASHFAQ