topic Qlikview 11 Dimension Group AccessPoint in QlikView

Qlikview 11 Dimension Group AccessPoint

qlik_venu — Fri, 11 Oct 2013 16:15:00 GMT

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

Re: Qlikview 11 Dimension Group AccessPoint

bbi_mba_76 — Fri, 11 Oct 2013 16:21:50 GMT

Hi,

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

Re: Qlikview 11 Dimension Group AccessPoint

qlik_venu — Fri, 11 Oct 2013 16:36:30 GMT

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