topic Re: Nested If Limit and Alternative for it. in QlikView

Nested If Limit and Alternative for it.

Anonymous — Thu, 18 Sep 2014 09:11:36 GMT

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

Re: Nested If Limit and Alternative for it.

jagan — Thu, 18 Sep 2014 09:17:14 GMT

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.

Re: Nested If Limit and Alternative for it.

MK_QSL — Thu, 18 Sep 2014 09:20:46 GMT

Nested If Limit is 99....

Re: Nested If Limit and Alternative for it.

Anonymous — Thu, 18 Sep 2014 09:26:51 GMT

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.

Re: Nested If Limit and Alternative for it.

Anonymous — Thu, 18 Sep 2014 09:32:16 GMT

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

Re: Nested If Limit and Alternative for it.

Anonymous — Thu, 18 Sep 2014 09:34:56 GMT

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