topic Expression - Counting Conditionally in QlikView

Expression - Counting Conditionally

Fri, 16 Dec 2011 16:44:03 GMT

Hello,

I have no experience of writing expressions in click view and could use a bit of help please.

I have data loaded with one field called admitmethod (possible values are '1' or '2'). I have a pivot table in which I want to count another field called CRN which

is a unique identifier for individuals, but I only want to count those with an admitmewthod of '2'.

How would I write the expression for this?

I have tried a few things but don't really understand the syntax. Thanks for any pointers....

Expression - Counting Conditionally

Sat, 17 Dec 2011 00:08:32 GMT

Count({<admitmethod = {'2'}>} CRN)

Re: Expression - Counting Conditionally

johnw — Sat, 17 Dec 2011 00:19:20 GMT

If the CRN and admitmethod are in the same table, it may be worth doing something like this in the load of that table:

if(admitmethod='2',CRN) as "CRN with Admit Method 2" // or whatever name makes sense

To simplify (and probably slightly speed up) your expression to this:

count("CRN with Admit Method 2")

Expression - Counting Conditionally

Mon, 09 Jan 2012 14:26:57 GMT

Thanks a lot John,

That is a very useful technique you highlight and works well for my purposes.

Dave.