QlikView Count Function

[Anonymous]

hello there,

i am new to the community so please be patient.

my problem is as follows i have certain Serverlists in Qlikview which have mostly two kinds of Status 'OK'  and 'not OK'.

I want to Count for example in the Field Status the occurence of the Status 'not Ok'

i tried already with several functions like

=Match(Status,'OLD','FAIL','OK')

=sum (TOTAL<AppServer>'not OK')

=substringcount(AppServer,'not OK')

especially the for example substringcount method does not return a value or null which is not correct as the underlying Excellists have in this field a status not OK

i am searching for a working function to really count all of the occurences of a certain string in a certain field.

Thanks in advance

[MarcoWedel]

please post some sample data and your expected result.

[vishsaggi]

‌ddid you try actual count function? Like

count({< Status = {‘not OK’} >} Status)

[shiveshsingh]

try Count function