topic Re: Count formula not working in QlikView

Count formula not working

cquesenbery — Tue, 07 Feb 2017 20:51:10 GMT

I need some help - I have tried many versions of " Count( {<[Total Units] = {“>=1”}>}DISTINCT [PatientID] )" and nothing is working. My original " Count (DISTINCT [PatientID]) "works but what I would like to do is only count distinct patients if the preceding column (Total Units) is greater than or equal to 1. What am I missing? Should I try an if statement? Thanks CQ

Re: Count formula not working

swuehl — Tue, 07 Feb 2017 21:05:25 GMT

What do you mean with "preceding column"?

[Total Units] need to be a field in the model if you want it to use like that.

How do the field values of [Total Units] look like? How are the fields related?

What is returned from your expression and what do you expect?

Re: Count formula not working

cquesenbery — Tue, 07 Feb 2017 21:20:08 GMT

This is what my chart looks like currently - I would like to only count the distinct patients if the total units are greater than 0 or >=1.

Re: Count formula not working

swuehl — Tue, 07 Feb 2017 21:24:23 GMT

So Total Unit is an expression?

=If("Total Units" >0, Count(DISTINCT PatientID) )

If(Column(1) >0, ....)

Re: Count formula not working

swuehl — Tue, 07 Feb 2017 21:25:48 GMT

Or maybe I misunderstood your request?

How does your expression look like?

Re: Count formula not working

cquesenbery — Tue, 07 Feb 2017 21:32:02 GMT

That worked - thank you so much for your help!!