Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
agigliotti
Partner - Champion
Partner - Champion

how to retrieve pivot table first dimension

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

1 Solution

Accepted Solutions
GaryGiles
Specialist
Specialist

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

View solution in original post

4 Replies
MayilVahanan

Hi @agigliotti 

in Qliksense, try like below

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

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
GaryGiles
Specialist
Specialist

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
Partner - Champion
Partner - Champion
Author

Hi @MayilVahanan ,

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

agigliotti
Partner - Champion
Partner - Champion
Author

Hi @GaryGiles ,

GetObjectField(0) worked!

It return the first dimension field name as needed.

Thanks.

Best Regards