Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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))