Qlikview 11 Nested Aggregation not allowed

[nikhilgandhi715]

Hi All,

I have just upgraded my Qlikview from V10 to V11. There is one application where in I am giving the user the functionality to select the dimension he wants to display in the Straight table. For this i am using below expression in the Presentation tab for conditional display of the dimension.

=

SubStringCount(GetFieldSelections(_Dimension,',',Count(_Dimension)),'Region')

This expression is working file in the v10, however I am getting an error of Nested aggregation not allowed in V11.

Is there something that i am  missing?

Any help would be much appreciated.

Thanks in advance.

Nikhil.

[Gysbert_Wassenaar · Accepted solution]

Try substringcount(GetFieldSelections(_Dimension,',',$(=count(_Dimension))),'Region')

[nikhilgandhi715]

Thanks Gysbert.

That just worked fine. Much appreciate the help.

Just a question.

Is this something changed in V11. Could you please let me know the reason behind this as this expression was working fine in V10.

[Gysbert_Wassenaar]

To be honest I have no idea. It could be a bug in QV10 (or a feature) or one in QV11. Or it could be a conscious design decision. I really don't know.