2 Replies Latest reply: May 10, 2017 4:16 PM by William Christensen RSS

    Set Analysis for Null condition (Qlik Sense)

    William Christensen

      I have a field called Delay flag and I want to count all occurrences of null values and some other conditions (simplified below into 1=1). The only values in the DelayFlag field are 1 and null. So I thought I could use the not 1 logic but this gives all zeros. Please help me rewrite this statement correctly. Thanks community!

       

      Count({<

      1=1

      ,DelayFlag = -  {'1'}

      //,DelayFlag =  Null

      >}

      Distinct Id)