Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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.
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