topic Qlikview 10 - Set Analysis in QlikView

Qlikview 10 - Set Analysis

Tue, 19 Oct 2010 12:21:38 GMT

Hello All,

I need to count the cases where 'Transfer' <> 'Yes'

Previously in Qlikview 9 I used the following :

Count({$<Transfer -= {'Yes'}>} Case)

Doesn't seem to be working in 10?!

Any guidance on this? Any changes to syntax in the new release?

Thanks.

Tue, 19 Oct 2010 13:22:45 GMT

Hi BR,

I also had that problem. To get around it, I would do something like:

if(Transfer <> 'Yes', Count(Case))

Tue, 19 Oct 2010 13:47:56 GMT

Hi ,

Try this

Count({$<Transfer = {*} - {'Yes'>} Case)

Tue, 19 Oct 2010 14:32:56 GMT

Wow, that would be unfortunate if the exclusion operator was removed in version 10. Hopefully, it's just a bug.

This should work too:

Count({$-<Transfer = {'Yes'}>} Case)

Wed, 20 Oct 2010 09:53:09 GMT

Thanks for your help guys,

BlockRocker \\m//