Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
mahinkle
New Contributor III

Making 2nd level headers from calculated 1st level column headers - Qlikview Pivot Table

Ive looked at several examples and cant figure out how to do this. All the examples seem to have the first level column names data in thier data.   This is not the case with my data.    The blue columns in my example (picture) are actual columns in the data.  however the rest of the data is calculated columns with diff column names.    Therefore Im having a problem figuring out how to create a top(2nd) grouping level.    The origional request was done in excel(pict ) but they want it move to QV.   Can anyone help me with the header issue?

HeaderOverHeaders.jpg

5 Replies
pokassov
Valued Contributor

Re: Making 2nd level headers from calculated 1st level column headers - Qlikview Pivot Table

Hi, Mary!

I think there is no solution to solve your problem.

You can use straight table and create only first level headers.

Best regards, Sergey

buzzy996
Honored Contributor II

Re: Making 2nd level headers from calculated 1st level column headers - Qlikview Pivot Table

may be,for second level u can create labels with test box's and manage with that.

and u can do ur calculations accordingly in first level expression by using ur first & second level fields.

Highlighted
mahinkle
New Contributor III

Re: Making 2nd level headers from calculated 1st level column headers - Qlikview Pivot Table

Ive looked into using the colored text boxes  however I run into a problem as my pivot table is in a container and I will have several pivot tables in this container (but luckily they will have the same format)    How do I do this 2nd level header  when inside a container?

Re: Making 2nd level headers from calculated 1st level column headers - Qlikview Pivot Table

‌please post sample data.

mahinkle
New Contributor III

Re: Making 2nd level headers from calculated 1st level column headers - Qlikview Pivot Table

I really cant as its private info....   The pict above is the best I can do...