Different interpretation between QlikView and Sense for Set Analysis?

trappersw — Tue, 20 Jun 2017 14:28:42 GMT

For this formula I get a different interpretation. Probably in this argument: ={">$(=2)"}. It seems to count >0 instead of >2.

Count(distinct {$<[Number of illnesses in the last 12 months]={">$(=2)"}>}[Employee code])

/Count(distinct [Employee code])

Someone any idea how to correct?

Re: Different interpretation between QlikView and Sense for Set Analysis?

sunny_talwar — Tue, 20 Jun 2017 14:39:08 GMT

What if you do this

Count(distinct {$<[Number of illnesses in the last 12 months]={'>2'}>}[Employee code])

/Count(distinct [Employee code])