Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi BR,
I also had that problem. To get around it, I would do something like:
if(Transfer <> 'Yes', Count(Case))
Hi ,
Try this
Count({$<Transfer = {*} - {'Yes'>} Case)
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)
Thanks for your help guys,
BlockRocker \\m//