topic Dynamic dimension handling in Qlik Aggr() function in App Development

Dynamic dimension handling in Qlik Aggr() function

lost_rabbit — Fri, 19 Sep 2025 17:34:45 GMT

Is there a way to pass a dynamic dimension into the Aggr function?
I tried using GetObjectDimension(0) directly inside Aggr, but it didn’t work.

If(GetObjectDimension(0) = 'Dim1', Only( {<[Group Flag] = {1}>} Aggr( Rank([Scores]), [Class], [School] ) ), If(GetObjectDimension(0) = 'Dim2', Only( {<[Group Flag] = {1}>} Aggr( Rank([Scores]), [Subject], [School] ) ) ) )

What I’d like is for the expression to dynamically use the dimension based on whatever the user picks from the alternate dimensions in the pivot table.

Re: Dynamic dimension handling in Qlik Aggr() function

SunilChauhan — Fri, 19 Sep 2025 13:01:13 GMT

although i did not understand properly. I Guess you should use System FIeld . there is a column which contains all the fieldName. May that Server your purpose

https://help.qlik.com/en-US/sense/May2025/Subsystems/Hub/Content/Sense_Hub/Scripting/system-fields.htm

Re: Dynamic dimension handling in Qlik Aggr() function

lost_rabbit — Fri, 19 Sep 2025 16:28:15 GMT

I need dynamic dimension so that the Aggr() function automatically picks the dimension from the pivot table, something like below but doesn't seem to work

Aggr(Rank([Scores]), GetObjectDimension(0), [School])

System field doesn't work for this

Re: Dynamic dimension handling in Qlik Aggr() function

Chanty4u — Mon, 22 Sep 2025 17:51:37 GMT

Try this.Dimension:

=ValueList('Class','Subject')

Measure:

Pick(

Match(ValueList('Class','Subject'),'Class','Subject'),

Aggr(Rank([Scores]), [Class], [School]),

Aggr(Rank([Scores]), [Subject], [Sch

ool])

)

Re: Dynamic dimension handling in Qlik Aggr() function

SunilChauhan — Wed, 24 Sep 2025 14:24:29 GMT

i am trying to simulate dynamic dimension using Qlikview. but sure we have same in Qliksense too.if you see above screen shot we can select from City and School. and Data rollup according to selection