
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nested If Limit and Alternative for it.
Hi All,
I've to create a report in which around 124 Nested If condition is being used.What is the limit of If's in nested if and is there alternative to it.
I am attaching the sample report structure for your help.I am not able to exceed 96 if within the nested if.
Thanks
Abhinav Pandey

.png)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
There is no limit for If() in Qlikview, if you have many If() then performance is not better. As an alternative to If() you can Match() or WildMatch().
Regards,
Jagan.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nested If Limit is 99....

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
from my point you need to keep kpi expressions in the row level and with pivot table chart move to columns.
with nested "if" and complex kpi expressions you will have a poor performance.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi ,
I am using pivot table.And yes I know there is issue of performance but the structure is fixed.So ,I've to do it as required.
Thanks
Abhinav

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I am using QV 11.2 SR5 version. and expression for each field is different.
