2 Replies Latest reply: Mar 4, 2016 4:10 PM by Khrisna Anzel Cagitla RSS

    Less than and Greater than in QlikView


      I would like to ask how can I add another condition as I was trying to


      1) Count the number of Active  Item


      2) If it's less than 12 but greater than 0 it should show Complete

      if not it should show In Progres.


      This expression works, but it shows in progress for 0

      = IF(Num(Count( {<[Active Status]={'Active'}>}[ItemName]),'####')<12,'In Progress','Complete')


      I hope you would help me.