Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Partner
Partner

Is there a way to get the column name instead of column no in pivot?

Hi,

I have this client requirement to be displayed output on a pivot. However, the formula for Grand Total, Sub Total, and each BU are different. See below the report template:

pivotreporttemplate.PNG

I tried to get the column no, but if certain group is expanded, the column no for "Grand Total" becomes 1 instead. Looking forward for the help!

Regards,

Bill

1 Reply
MVP
MVP

Re: Is there a way to get the column name instead of column no in pivot?

I think both GetObjectField() function to retrieve the name of the dimension along with the Dimensionality() function could be of great help to you.