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

    Less than and Greater than in QlikView

    Khrisna Anzel Cagitla

      Hi,

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

       

      1) Count the number of Active  Item

      then

      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.

       

       

      Thanks.