topic Re: Using GetObjectDimension in Aggr in App Development

Using GetObjectDimension in Aggr

timpoismans — Wed, 21 Nov 2018 08:59:43 GMT

Is there way in how we can use the function GetObjectDimension in the Aggr-function?

GetObjectDimension returns the name of a dimension, but this is not sufficient for the Aggr-function.

Anyone knows about a possible solution to this problem?

P.S.: Adding square brackets to the function as in '[' & function & ']' won't work.

Kind regards,

Tim P.

Re: Using GetObjectDimension in Aggr

Anil_Babu_Samineni — Wed, 21 Nov 2018 09:04:23 GMT

May be this?

Aggr(Sum(Measure), $(='[' & GetObjectDimension(Dimensionality()) & ']')

Re: Using GetObjectDimension in Aggr

timpoismans — Wed, 21 Nov 2018 09:13:53 GMT

Sadly this doesn't work.

I'm trying to use it as follows:

=Aggr(Dual(Dim1,RowNo(total)),$(='[' & GetObjectDimension(0) & ']'),$(='[' & GetObjectDimension(1) & ']'))

Using hard values for GetObjectDimension while testing.

Re: Using GetObjectDimension in Aggr

Anil_Babu_Samineni — Wed, 21 Nov 2018 09:31:13 GMT

Usually, This will work? What you want to bring using GetObjectDimension() ??

Aggr(Sum(Measure), $(=Concat(DISTINCT Chr(39) & '[' & GetObjectDimension(Dimensionality()) & ']' & Chr(39)))

Re: Using GetObjectDimension in Aggr

timpoismans — Wed, 21 Nov 2018 09:42:17 GMT

Tried adding the Concat (red) part, still does not work.

I'm working in a pivot table and want to get the current dimension as well as the dimensions on top.

E.g.: If roman numerals are my top dimension (I, II, III, IV,...) and they split in (A, B, C, D, ...)

=Aggr(Dual(A,RowNo(total)),I,A)

Would be the result if I insert the result of GetObjectDimension in my calculated dimension.

Re: Using GetObjectDimension in Aggr

Anil_Babu_Samineni — Wed, 21 Nov 2018 12:58:21 GMT

Can you please share sample test file to investigate? time being, Can you add -1 also

GetObjectDimension(Dimensionality())-1

Re: Using GetObjectDimension in Aggr

timpoismans — Wed, 21 Nov 2018 13:18:04 GMT

Working on different projects at the moment, will only be able to provide a test file coming Friday.

Adding -1 doesn't work either. And I'm using a hard 0 and 1 at the moment instead of Dimensionality for testing purposes.

Re: Using GetObjectDimension in Aggr

diagonjope — Fri, 05 Apr 2019 23:48:13 GMT

Greetings!

Did you ever get this to work? I am trying to do something similar to what your are describing: using AGGR() to get the max value of an expression in order to provide the Max value for the axis values on a dispersion chart, and I need to get the value of the current Dimension among all the Alternatives.

What I find interesting in my case is that it seems to work for one of the axis but not for the other.

Cheers,

--José

Re: Using GetObjectDimension in Aggr

praichubb — Thu, 25 Jun 2020 14:57:25 GMT

Hi Tim,

I have a very similar issue... where I want to be able to change the order of the aggregation depending on how the user pivots the Chart on Qliksense. Where you able to use GetObjectDimension successfully in Qlik Sense? can you provide and example ? Thanks.

sum(Aggr(Sum({<[Year]={$(=(vPriorYear))}>}[C_Amount])
/
Sum({<[Year]={$(=(vPriorYear))}>}[P_Amount])
*
Sum({<[Year]={$(=(vCurrentYear))}>}[P_Amount]),

[Industry], [State],[Region] )))

Re: Using GetObjectDimension in Aggr

TPoismans — Thu, 25 Jun 2020 15:09:46 GMT

Hey Praichubb

As it's been a while, I can't say for sure if we got it working, but I think we did.

Sadly, this topic is about one of my old projects under my former employer and I couldn't keep any of the applications, so I can't provide you with any examples, sorry.

Regards,
Tim P.

Re: Using GetObjectDimension in Aggr

JulieJoseph — Tue, 26 Mar 2024 12:59:01 GMT

Hi praichubb,

I am having a similar issue where I want to do an aggregation based on the two dimensions which are selected (From a list of alternate dimensions)for a chart. Were you able to get a solution for this successfully. If yes, Could you please share the same here.

Regards,

Julie

Re: Using GetObjectDimension in Aggr

Alvaro__ — Thu, 09 May 2024 17:07:43 GMT

Instead of GetObjectDimension you can try using GetObjectField:

Aggr(Sum(Measure), $(='[' & GetObjectField() & ']'))