Loading...

A count for distinct values from SharePoint list

A count for distinct values from SharePoint list

Home Forums QuickApps Forum A count for distinct values from SharePoint list

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • #4107
      Anonymous
      Anonymous
      Participant

      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

    • #5197
      Anonymous
      Anonymous
      Participant

      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

Viewing 1 reply thread

You must be logged in to reply to this topic.