Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2013-12-26 11:46 PM

Pivot Table

I want to create a pivot table made of the following excel spreadsheet attached.

When I select A1 i want to see the following pivot table:

Supports2nd Level Supports
A2A4
A1
A3A4
A5
A6
Preview file
9 KB
458 Views
0 Likes
1 Reply
Anonymous
Not applicable
‎2013-12-27 01:16 AM
Author

You need to use the Hierarchy statements in the script.

See the attached for a simple example.

The below link is a great resource to get Hierarchies integrated properly into your application.

http://community.qlik.com/docs/DOC-4823

test.qvw
339 Views
0 Likes