topic Re: Conditional Count in expression in QlikView

Conditional Count in expression

Anonymous — Mon, 05 Aug 2013 13:35:14 GMT

I have created a conditional count in an expression, however when I show this as a count in a pivot it shows it as '-1' and does not count this. How can I count this correctly?

My formula in my expression is below:

Count

({$<[1HR Start Date]={'In Process'}>} [1HR Start Date])

and

count({$<[HR Recruitment]-={''}>} [HR Recruitment])

Although the output filters the correct records it does not count in the pivot table (last column)

Any help appreciated

Phil

Re: Conditional Count in expression

swuehl — Mon, 05 Aug 2013 13:41:34 GMT

You've created a boolean expression, so possible results are 0 and -1 or FALSE and TRUE.

If you want to get a count of something, try like this:

Count({$<[1HR Start Date]={'In Process'}, [HR Recruitment] -={''} >} [1HR Start Date])

Instead of [1HR Start Date] you might need to count another field, whatever seems appropriate to your requirements.

Re: Conditional Count in expression

Anonymous — Mon, 05 Aug 2013 14:03:16 GMT

This worked great. Thanks

Phil

Re: Conditional Count in expression

Anonymous — Mon, 05 Aug 2013 14:03:32 GMT

This worked great. Thanks

Phil