2 Replies Latest reply: May 29, 2017 1:33 PM by taj mohamed RSS

    Count if and distinct

    DANIEL ARAUJO

      Dear All,

       

      I am pretty new using set analysis and I am having some trouble while calculating an Indicator through a database on qlikview.

       

      The base has the structure below. What I want to do is to count the number of distinct IDs which has number 1 in the column on the right ("Raw Material"). This column may be 1 or 0 in one same ID.

       

      For instance, the calculation using the base below has to be 2.

       

      Can someone help me?

       

      ID Raw Material
      11
      10
      11
      21
      21
      21
      30
      30