Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld starts MONDAY! last chance to register is now ! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
bill_mtc
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
petter
MVP
MVP

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