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

Announcements
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
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'))