Solved: Re: Set analysis distinct - Qlik Community

Report Inappropriate Content · ‎2014-07-07

Hi All,

I have the expression =Count({$<Type={'Weekly Contact'}>}[MeetingSubID]). How can I tweak this so that it counts on distinct MeetingSubID (This field has duplicates).

Thank you

H

jonathandienst · ‎2014-07-07

=Count({$<Type={'Weekly Contact'}>} DISTINCT [MeetingSubID])

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

jonathandienst · ‎2014-07-07

=Count({$<Type={'Weekly Contact'}>} DISTINCT [MeetingSubID])

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

its_anandrjs · ‎2014-07-07

Try like

=Count( DISTINCT {$<Type={'Weekly Contact'}>} [MeetingSubID])

Report Inappropriate Content · ‎2014-07-07

Perfect, thank you