sum 3 counts

[#1]

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?

[lironbaram · Accepted solution]

try this

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

[CELAMBARASAN]

Hi,

     Try with this expression

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

Celambarasan

[#4]

no succes

I'm getting 0 as result.

[lironbaram]

can you post sample data

it should work

[#6]

Hi

What you have used is appropriate only thing is you should use "Double Quotes" instead of single one as mentioned below.

Count({<prioname={"Blocker"}, sname <> {"Afgehandeld"}>}iid)

If it still doesn't work, please share sample data / attachment.

[#7]

no doesn't work

• I have 1 project in my issue database
  • In this project there are 10 "minor" (prioname=Minor) priority issues
  • In this project there are 9 "Blocker" (prioname=Blocker) priority issues
    • from the 9 "Blocker" issiues there are 5 not "afgehandeld" (afgehandeld=sname)
      •      2 are status(sname) "verification"
      •      2 are status(sname) "vestgelegd"
      •      1 is status(sname) "In behandeling"
    • from the 9 "Blocker" issiues there are 4 issues with status(sname) "afgehandeld"

Hope this makes some clear?

[#8]

Is this enough info? of do you need more?

[#9]

Can you attach the sample QVW file?

[#10]

Well, i don't know what happned, But after resarting Qlikview .. the solutions which where sugested, worked!

Thnx all for the help