Home › Forums › QuickApps Forum › A count for distinct values from SharePoint list
- This topic is empty.
- AuthorPosts
-
- 06/01/2012 at 8:14 am #4107
AnonymousParticipantHi,
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
- 06/01/2012 at 8:14 am #5197
AnonymousParticipantHi 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
-
- AuthorPosts
You must be logged in to reply to this topic.