Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
May be this?
Aggr(Sum(Measure), $(='[' & GetObjectDimension(Dimensionality()) & ']')
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.
Usually, This will work? What you want to bring using GetObjectDimension() ??
Aggr(Sum(Measure), $(=Concat(DISTINCT Chr(39) & '[' & GetObjectDimension(Dimensionality()) & ']' & Chr(39)))
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.
Can you please share sample test file to investigate? time being, Can you add -1 also
GetObjectDimension(Dimensionality())-1
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.
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é
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] )))
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.