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

Profiling - Distinct Field Values (per field)

Hi Everyone,

Is there a good way, when profiling a new data set, to show the distinct values per field?

I've got the following working in a straight table (with dimensions $Table and $Field), when any single field is selected:

     =Num(Count(Distinct [$(=$Field)]), '#,##0')

...but ONLY when a single field is selected.  If 2+ fields are selected, the straight table is blank.  It would be immensely helpful to see the distinct values in each field.

Any ideas?

Thanks,

DJ

1 Solution

Accepted Solutions
Not applicable
Author

1 Reply
Not applicable
Author

Found it:

http://community.qlik.com/message/385216#385216

Thanks, Ralf, for the solution.