Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
trappersw
Partner - Creator
Partner - Creator

Different interpretation between QlikView and Sense for Set Analysis?

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?

1 Reply
sunny_talwar

What if you do this

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

/Count(distinct [Employee code])