Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Daniel1908
Creator
Creator

Count Double Entries in a Table

Hello Together, 

I am using the below expression. 

=Count(distinct{$-1<Material>} If([Price]>1,1,0))

I want to count the material where the equal price appears more than once in the list. 

Thanks for your help. 

Kind Regards, 
Daniel

1 Reply
Kushal_Chawda

@Daniel1908  try below. If doesn't worl share sample data with expected output.

= count(if(aggr(count(Price),Material,Price) > 1 , Material))