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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to find distinct data points per person

Hi there,

I am looking for a way to list distinct data points on a user and then show it in groups after.

Example is a I have an email, name, zip code, and birthday for Bob.  That would be 4 data points.  We only have Susan's Name and Birthday so that's only 2 data points.

Then I could also do a sum of people with 2 data points and so on.

The data would be null in the fields if there isn't any collected yet for that person.

A table simplified like this for example:

    

usernameemailzipcodebirthday
BobDBob KellyBob@Kelly.com9021012/12/2001
Susan OSusan OleadeSusan@O.com
DaveCDave Clarke10001
20 Replies
sunny_talwar

I never tested this with a key field, but that could be the issue. This expression isn't my own creation, so have not tested it fully. Is there any other field you can use which you know would not be null and will always be available?