Profiling - Distinct Field Values (per field)

Thu, 21 Mar 2013 09:49:15 GMT

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,

Re: Profiling - Distinct Field Values (per field)

Tue, 15 Oct 2013 06:16:02 GMT

Found it:

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

Thanks, Ralf, for the solution.

topic Profiling - Distinct Field Values (per field) in QlikView

Profiling - Distinct Field Values (per field)

Re: Profiling - Distinct Field Values (per field)