topic Show the particular Count of status in QlikView

Show the particular Count of status

Wed, 08 Jul 2015 07:06:17 GMT

Hi

I want to show particular count of Status without select a Status value.

Ex:

Status

Good

Better

Best

Good

Better

Best

Good

Better

Best

Good

Better

Best

In the above column without select a value "Good", I need show the count of Good

Re: Show the particular Count of status

lironbaram — Wed, 08 Jul 2015 07:13:02 GMT

hi two options:

count (if(Status='Good',Status))

count({<Status={'Good'}>}Status)

Re: Show the particular Count of status

MK_QSL — Wed, 08 Jul 2015 07:15:40 GMT

Count({$<Status = {'Good'}>}Status)

or

Count({1<Status = {'Good'}>}Status)