topic sum 3 counts in QlikView

sum 3 counts

Thu, 16 Feb 2012 07:03:03 GMT

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?

sum 3 counts

lironbaram — Thu, 16 Feb 2012 07:05:48 GMT

try this

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

sum 3 counts

CELAMBARASAN — Thu, 16 Feb 2012 07:10:34 GMT

Hi,

Try with this expression

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

Celambarasan

sum 3 counts

Thu, 16 Feb 2012 07:24:41 GMT

no succes

I'm getting 0 as result.

sum 3 counts

lironbaram — Thu, 16 Feb 2012 07:29:48 GMT

can you post sample data

it should work

sum 3 counts

Thu, 16 Feb 2012 07:31:58 GMT

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.

sum 3 counts

Thu, 16 Feb 2012 07:53:40 GMT

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?

sum 3 counts

Thu, 16 Feb 2012 10:40:24 GMT

Is this enough info? of do you need more?

sum 3 counts

Thu, 16 Feb 2012 10:46:44 GMT

Can you attach the sample QVW file?

sum 3 counts

Thu, 16 Feb 2012 12:59:41 GMT

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

Thnx all for the help