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

    COUNT DISTINCT on some fields

    Mor Rave

      Hi,

      I need some help with an expression on Qlik Sense.

      I have the data table below

        

      DR_GIDError IDKPI_DESC
      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.

      Mor