Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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])