2 Replies Latest reply: Feb 21, 2012 2:54 AM by roytje001

# expression if > fails

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

• ###### expression if > fails

Hi,

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

You can generate If expression by using the following http://www.qlikblog.at/464/tool-creating-nested-ifstatements/

Regards,

Jagan.

• ###### expression if > fails

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