topic Re: how to retrieve pivot table first dimension in App Development

how to retrieve pivot table first dimension

agigliotti — Fri, 14 May 2021 07:28:55 GMT

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

Re: how to retrieve pivot table first dimension

MayilVahanan — Fri, 14 May 2021 10:38:35 GMT

Hi @agigliotti

in Qliksense, try like below

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

Re: how to retrieve pivot table first dimension

GaryGiles — Fri, 14 May 2021 10:41:11 GMT

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

Re: how to retrieve pivot table first dimension

agigliotti — Fri, 14 May 2021 12:45:56 GMT

Hi @MayilVahanan ,

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

Re: how to retrieve pivot table first dimension

agigliotti — Fri, 14 May 2021 12:47:32 GMT

Hi @GaryGiles ,

GetObjectField(0) worked!

It return the first dimension field name as needed.

Thanks.

Best Regards