Dynamic dimension handling in Qlik Aggr() function

[lost_rabbit]

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.

[SunilChauhan]

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.h...

[lost_rabbit]

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

[Chanty4u]

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])

)

[SunilChauhan]

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