8 Replies Latest reply: Feb 2, 2012 10:43 AM by bill_robbins777 RSS

    Countif for positive and negative numbers in a dimension...

      Hi.  I am very new to Qlikview and a little stuck.

       

      In MS Excel, I would use, "countif("A:A",">0")

       

      I am trying to count how many items in a column are greater than 0 and how many are less than 0 and represent this as a separate calculated dimension.

       

      Can anyone help?

       

      Thank you.

       

      Regards,

       

      Bill.