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.