Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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).
Hi @agigliotti
in Qliksense, try like below
GetObjectDimension(0) -> gives the first dimension field name.
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).
Hi @MayilVahanan ,
Thanks for your fast reply, but unfortunately it does not works.
Hi @GaryGiles ,
GetObjectField(0) worked!
It return the first dimension field name as needed.
Thanks.
Best Regards