QlikView Count Function

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: QlikView Count Function

MarcoWedel — Mon, 28 May 2018 21:25:46 GMT

please post some sample data and your expected result.

Re: QlikView Count Function

vishsaggi — Mon, 28 May 2018 21:45:52 GMT

‌ddid you try actual count function? Like

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

Re: QlikView Count Function

shiveshsingh — Tue, 29 May 2018 04:37:37 GMT

try Count function

topic Re: QlikView Count Function in QlikView

QlikView Count Function

Re: QlikView Count Function

Re: QlikView Count Function

Re: QlikView Count Function