topic Creating a Pivot Table with multiple headers in QlikView

Creating a Pivot Table with multiple headers

Thu, 10 Sep 2015 14:05:34 GMT

I am still quite new to creating tables in QlikView and need help creating the attached from my data.

All variables are available and/or created in my load statement. I need help creating a table that looks like the table in the attached Excel file. I have tried a straight table and a pivot table, but cannot seem to figure out how to get all the main column headers (State, User, Cases, Days) and just have the date as the rows.

Thank you!

Re: Creating a Pivot Table with multiple headers

jonathandienst — Thu, 10 Sep 2015 14:14:47 GMT

Use a pivot table.

If the column headers are from a dimension, you can drag the column to the top of the table. The drag indicator willl change to a horizontal arrow; drop the "column" into the top row. This will arrange the dimension as column headers. Is this what you mean?

Re: Creating a Pivot Table with multiple headers

Thu, 10 Sep 2015 14:33:23 GMT

You are awesome and made my day!!!! Thank you so much.

Re: Creating a Pivot Table with multiple headers

UV — Fri, 11 Oct 2019 12:05:47 GMT

hi ,I have to create sub titles (Previous qtr and Current Qtr) as below for the expression Revenue, Cost and Profit ,loss respectively in pivot table, then how those subtitle can be created?