11 Replies Latest reply: Aug 1, 2017 12:13 PM by Sunny Talwar RSS

    only function qlik sense

    Joanna Seldon

      Hi

       

      I only want to count IDS, that have ONLY had temperature observations of 35

       

      i.e

       

      ID  Obs Temp

      1    1      35

      1    2      35

      1    3      35

      2    1      35

      2    2      36

      2    3      35

      2    4      37

      3    1      35

      3    2      35

      3    3      35

      3    4      36

       

      I should only return ID 1

       

      Please help