Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

How to count the non unique values per field in a pivot table?

Hi, How do I count the non-unique values per field in a pivot table?

sample output:

                                             Field1          Field2      ....

Number of duplicates          5               20

% to total                              1%          50%

Thanks a bunch in advance. Cheers!

1 Reply

Re: How to count the non unique values per field in a pivot table?

Please check enclosed file..

Community Browser