Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Creating a Pivot Table with multiple headers

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!

Tags (2)
1 Solution

Accepted Solutions
MVP
MVP

Re: Creating a Pivot Table with multiple headers

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?

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
2 Replies
MVP
MVP

Re: Creating a Pivot Table with multiple headers

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?

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable

Re: Creating a Pivot Table with multiple headers

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

Community Browser