Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Qlikview 10 - Set Analysis

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.

4 Replies
Not applicable
Author

Hi BR,

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

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

Not applicable
Author

Hi ,

Try this

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

Not applicable
Author

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)


Not applicable
Author

Thanks for your help guys,

BlockRocker \\m//