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

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

Anonymous — Thu, 07 May 2015 14:44:51 GMT

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?

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

pokassov — Thu, 07 May 2015 15:29:00 GMT

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

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

buzzy996 — Thu, 07 May 2015 16:00:45 GMT

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.

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

Anonymous — Mon, 11 May 2015 18:46:41 GMT

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

MarcoWedel — Mon, 11 May 2015 18:54:50 GMT

‌please post sample data.

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

Anonymous — Mon, 11 May 2015 18:57:11 GMT

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