Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
YOSHIDA_T
Partner - Contributor III
Partner - Contributor III

How to get a Dimension Name for pivot table

Hi

As shown in the image below, 

I want to get a dimension name for pivot table.

Is there a function that can achieve this?

 

こんにちは

ピボットテーブルにおいて下記画像のように、軸名を取得するメジャーを作成したいです。

これを実現する関数はありますか?

YOSHIDA_T_2-1771549744241.png

 

 

1 Reply
marcus_sommer

You may try:

getobjectfield(dimensionality())

or maybe a conditional approach, like:

if(dimensionality() = 0, 'x', if(dimensionality() = 1, 'y', 'z'))