Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

QlikView Count Function

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

3 Replies
Highlighted

please post some sample data and your expected result.

Highlighted
Champion III
Champion III

‌ddid you try actual count function? Like

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

Highlighted
Master
Master

try Count function