https://community.qlik.com/t5/Search-the-Community/Get-which-dimension-fields-is-first-in-a-pivot-table-Qlik/m-p/1801308#M291 <PRE><SPAN class="Y2IQFc">I have a pivot table that its analysis set varies depending on the dimension. It works correctly with the "Dimensionality () function. "The problem is when the user moves the dimensions. Can someone help me to retrieve the field name of the first dimension? Thank you so much<BR /><BR /><BR />Metric<BR />example<BR />if(<SPAN>Dimensionality ( )=1, sum(sales),sum(sale)-sum(cost))<BR /></SPAN></SPAN><SPAN class="Y2IQFc"><BR /><BR /></SPAN></PRE> Wed, 21 Apr 2021 12:52:14 GMT Landalux 2021-04-21T12:52:14Z https://community.qlik.com/t5/Search-the-Community/Get-which-dimension-fields-is-first-in-a-pivot-table-Qlik/m-p/1801308#M291 <PRE><SPAN class="Y2IQFc">I have a pivot table that its analysis set varies depending on the dimension. It works correctly with the "Dimensionality () function. "The problem is when the user moves the dimensions. Can someone help me to retrieve the field name of the first dimension? Thank you so much<BR /><BR /><BR />Metric<BR />example<BR />if(<SPAN>Dimensionality ( )=1, sum(sales),sum(sale)-sum(cost))<BR /></SPAN></SPAN><SPAN class="Y2IQFc"><BR /><BR /></SPAN></PRE> Wed, 21 Apr 2021 12:52:14 GMT https://community.qlik.com/t5/Search-the-Community/Get-which-dimension-fields-is-first-in-a-pivot-table-Qlik/m-p/1801308#M291 Landalux 2021-04-21T12:52:14Z https://community.qlik.com/t5/Search-the-Community/Get-which-dimension-fields-is-first-in-a-pivot-table-Qlik/m-p/1801867#M297 <P>Maybe you could use:</P><P><A href="https://help.qlik.com/en-US/sense/February2021/Subsystems/Hub/Content/Sense_Hub/Scripting/SystemFunctions/GetObjectField.htm" target="_blank">GetObjectField - chart function ‒ Qlik Sense on Windows</A></P><P>- Marcus</P> Thu, 22 Apr 2021 15:55:48 GMT https://community.qlik.com/t5/Search-the-Community/Get-which-dimension-fields-is-first-in-a-pivot-table-Qlik/m-p/1801867#M297 marcus_sommer 2021-04-22T15:55:48Z