topic expression if > fails in QlikView

expression if > fails

Mon, 20 Feb 2012 15:00:09 GMT

Hello

I need some help with the following expression

IF((Count({<prioname={'Blocker'}, stringvalue={'FAT'}>}iid)) > SUM({<Soort={'Blocker'}>} Aantal), 1,

IF((Count({<prioname={'Critical'}, stringvalue={'FAT'}>}iid)) > SUM({<Soort={'Critical'}>} Aantal), 2,

IF((Count({<prioname={'Major'}, stringvalue={'FAT'}>}iid)) > SUM({<Soort={'Major'}>} Aantal), 3,

IF((Count({<prioname={'Minor'}, stringvalue={'FAT'}>}iid)) > SUM({<Soort={'Minor'}>} Aantal), 4,0

))))

values

(Count({<prioname={'Blocker'}, stringvalue={'FAT'}>}iid) = 4

(Count({<prioname={'Critical'}, stringvalue={'FAT'}>}iid) = 0

(Count({<prioname={'Major'}, stringvalue={'FAT'}>}iid) = 8

(Count({<prioname={'Minor'}, stringvalue={'FAT'}>}iid) = 13

SUM({<Soort={'Blocker'}>} Aantal) = 15

SUM({<Soort={'Critical'}>} Aantal) = 15

SUM({<Soort={'Major'}>} Aantal) = 15

SUM({<Soort={'Minor'}>} Aantal) = 15

Question:

If i run this the result is 3. but Why? i expect it to be 0

jagan — Mon, 20 Feb 2012 15:24:17 GMT

Hi,

Your If expression seems to be perfect. Just cross check the values.

Regards,

Jagan.

Tue, 21 Feb 2012 07:54:04 GMT

I checked the values ... If i run them i get the values as stated in my original post.

But I have the answer. I had added a demention on Aantal. This was the problem.

removed it an it works as a shine