6 Replies Latest reply: Jan 1, 2018 11:14 PM by pradosh thakur RSS

    COUNT DISTINCT on some fields

    Mor Rave


      I need some help with an expression on Qlik Sense.

      I have the data table below


      3123415Data Accuracy
      3123814Data Accuracy
      3126912Data Accuracy
      3130015Data Accuracy
      3130012Data Accuracy
      3130012Data Accuracy
      310005Data Completeness


      I would like to count all the DR_GID with KPI_Desc= "Data Accuracy" but with unique Error ID

      For example:  for DR_GID=31300 the result would to be 2


      I don't know how to write the set analysis correctly

      I hope someone can help me with this.


      Thanks for your help.