how to retrieve pivot table first dimension

[agigliotti]

Hi,

Is there a way to get the first dimension name within a pivot table?
I'd need to trigger a warning message to the user (calculation condition) in case the first dimension is not correct for that  analysis.

Could someone help me to achieve it?

Many thanks in advance for your time.

Best Regards
Andrea

[MayilVahanan]

Hi @agigliotti 

in Qliksense, try like below

GetObjectDimension(0)  -> gives the first dimension field name. 

[GaryGiles · Accepted solution]

Have you tried using the GetObjectDimension() and/or GetObjectField() functions?  They will retrieve the Dimension field label and Dimension field definition, respectively, based on the number that you pass, starting with 0.  So to retrieve information on the first field of a dimension, it would be GetObjectDimension(0) and GetObjectField(0).

[agigliotti]

Hi @MayilVahanan ,

Thanks for your fast reply, but unfortunately it does not works.

[agigliotti]

Hi @GaryGiles ,

GetObjectField(0) worked!

It return the first dimension field name as needed.

Thanks.

Best Regards