Qlikview 11 Dimension Group AccessPoint

[qlik_venu]

Hi,

We are using a dimension group in our bar chart. When we have the null values in the data, we use 'Projects' text. This conditional statement was working fine in the Access point in Qlikview 10.

But now in Qlikview 11, though in client the values appear, when we move it to Access Point the same is not working. We are not getting the text as "Project' whenever there is a Null value.

The expression used,

if( isNull([Portfolio Hierarchy]), 'Projects', [Portfolio Hierarchy])

[Portfolio Hierarchy] is the Dimension Group we had used.

Can you please suggest me on this.

Thanks,

VEnu

[bbi_mba_76]

Hi,

maybe you could try to replace the isNull([Portfolio Hierarchy]) with len([Portfolio Hierarchy])>0

[qlik_venu]

Hi,

Thanks,

The len() is also not working.

In Qlikview 10, even if we had a error message in the expression, the

calculation would work fine in AP.

But I am not sure why the same are not working in Qlikview 11.

Any other ideas,

Thanks,

Venu