Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Count unique records

Hello,
this is an example of what I need.


I need to count the first time that a concrete ID appears. If an ID appears twice I only want it to be counted once.


Can you help me?

thanks


2 Replies
swuehl
MVP
MVP

Sorry, it's absolutely unclear to me looking at your description and the qvw what you are trying to achieve. Please describe your requirements a bit more detailed, best with some sample results you want to obtain from your data set.

vardhancse
Specialist III
Specialist III

if you want only unique id count add expression similar to below:

Count(Distinct(ID))