Nested If Limit and Alternative for it.

[Anonymous]

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

[jagan]

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.

[MK_QSL]

Nested If Limit is 99....

[Anonymous]

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.

[Anonymous]

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

[Anonymous]

I am using QV 11.2 SR5 version. and expression for each field is different.