9 Replies Latest reply: Feb 16, 2012 7:59 AM by roytje001 RSS

    sum 3 counts

      Hello,

       

      Im preety new to qlikview an I have a problem which i can't solve

       

      SITUATION

      • I have a issue database
      • have 4 status namens (sname): 'Vastgelegd',  'Verificatie', 'In Behandeling' and 'Afgehandeld'
      • I also have 3 prio names: Blocker, Critical, Minor

       

       

      PROBLEM

      I want to sum 3 counts where prioname = blocker and sname is not Afgehandeld :

       

      I HAVE TRIED:

      • Count({<prioname={'Blocker'}, sname <> {'Afgehandeld'}>}iid)
      • sum(Count({<prioname={'Blocker'}, sname = {'Vastgelegd'}>}iid)

                Count({<prioname={'Blocker'}, sname = {'Verificatie'}>}iid)

                     Count({<prioname={'Blocker'}, sname = {'In Behandeling'}>}iid))

       

      Above don't work

      somebody any idea how to do this?