topic Re: Qlikview 11 Nested Aggregation not allowed in QlikView

Qlikview 11 Nested Aggregation not allowed

nikhilgandhi715 — Wed, 25 Feb 2015 13:02:13 GMT

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.

Re: Qlikview 11 Nested Aggregation not allowed

Gysbert_Wassenaar — Wed, 25 Feb 2015 13:11:09 GMT

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

Re: Qlikview 11 Nested Aggregation not allowed

nikhilgandhi715 — Wed, 25 Feb 2015 13:26:46 GMT

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.

Re: Qlikview 11 Nested Aggregation not allowed

Gysbert_Wassenaar — Wed, 25 Feb 2015 14:59:48 GMT

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.