If Else condition or nested if

[#1]

Hi,

Is it possible to use nested if in the Dimension ?

[Miguel_Angel_Baeyens]

Hello,

Although it's actually possible, performance will be affected seriously. If possible, I'd recommend you to create aggregated dimensions, or create a field in the load script and then use it as dimension.

Hope that helps

[Stefan_Walther]

Hi,

as Miguel already stated, nested ifs can really be a serious performance problem (when dealing with large datasets). Otherwise you could use them ...

If your are struggling with the syntax you could use the little tool I have published: http://www.qlikblog.at/464/tool-creating-nested-ifstatements/

Regards, Stefan