Profiling - Distinct Field Values (per field)

[#1]

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

[#2 · Accepted solution]

Found it:

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

Thanks, Ralf, for the solution.