Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
baarathi
Creator III
Creator III

I want to get the count of id, grouping by id and date(if a same id is present in same date n times it should be considered as 1 count) whereas the same id can be in n different dates, then the count is n.

Aggr(Count({<Amount = {">0"}, A = {"0*"} , A -= {"0000*"}>}Id) ?

5 Replies
agigliotti
Partner - Champion
Partner - Champion

maybe it's simple as Count( {<Amount = {">0"}, A = {"0*"} , A -= {"0000*"}>} Distinct Id & Date ) ?

baarathi
Creator III
Creator III
Author

distinct id, for a particular day, is fine(it will give single count). But for different days it should be treated as another count

sunny_talwar

The above should be counting an id on another date as a new observation... have you tried it already?

zebhashmi
Specialist
Specialist

you can Make a new field hash128(ID, Date) as Newfield and count distinct

agigliotti
Partner - Champion
Partner - Champion

yes it does.