A count for distinct values from SharePoint list

[Anonymous]

Hi,

How to get a count for distinct values from SharePoint list?

List has data as mentioned below:

Column1

ABC1ABC2ABC1ABC3ABC4ABC3

Count : 6

Required out:

Column2

ABC1ABC2ABC3ABC4

Count : 4

Please let me know if you need any information on this.

Regards,N.Srinivas

[Anonymous]

Hi Richard,

If you want to display a list of the distinct values, you can configure qSelector to a SharePoint list with "Remove duplicate values" option enabled.

If you would like to get a count of distinct values, you will have to write some custom JavaScript function and use it with qListView, as we do not have a property that can handle this functionality in yet.

Yuan

[Author]

Posts