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

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
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


Labels (1)
2 Replies
swuehl
Champion III
Champion III

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))