Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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.

Tags (1)
4 Replies
Not applicable

Qlikview 10 - Set Analysis

Hi BR,

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

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

Not applicable

Qlikview 10 - Set Analysis

Hi ,

Try this

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

Not applicable

Qlikview 10 - Set Analysis

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

Qlikview 10 - Set Analysis

Thanks for your help guys,

BlockRocker \\m//

Community Browser