Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
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))