# New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Not applicable

## Count for specific values

I have the following table

department       Overall Satisfaction

---------------       ------------------------------

Inpatient            Extremely Satisfied

Inpatient            Satisfied

Outpatient         dissatisfied

Inpatient           dissatisfied

Outpatient         Satisfied

I want to get the following formula ( Extremely satisfied + Satisfied) of inpatient / Count( department = 'Inpatient)

1 Solution

Accepted Solutions
MVP & Luminary

## Re: Count for specific values

Try:

count({<[Overall Satisfaction']={'Extremely Satisfied','Satisfied'},department={'Inpatient'}>} department) / count({<department={'Inpatient'}>}department)

or maybe you want to count Satisfied or Extremely Satisfied for both departments and then divide by the count of department Inpatient:

count({<[Overall Satisfaction']={'Extremely Satisfied','Satisfied'>} department) / count({<department={'Inpatient'}>}department)

talk is cheap, supply exceeds demand
2 Replies
MVP & Luminary

## Re: Count for specific values

Try:

count({<[Overall Satisfaction']={'Extremely Satisfied','Satisfied'},department={'Inpatient'}>} department) / count({<department={'Inpatient'}>}department)

or maybe you want to count Satisfied or Extremely Satisfied for both departments and then divide by the count of department Inpatient:

count({<[Overall Satisfaction']={'Extremely Satisfied','Satisfied'>} department) / count({<department={'Inpatient'}>}department)

talk is cheap, supply exceeds demand
Not applicable

## Re: Count for specific values

Thanks dude your a life saver