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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Creating a multidimensional table

My data model has one person associated to many programs, and each program has many attributes.  I'd like to be able to show something like:

person1 - program 1:1 - att1 - att2 - att3

            - program 1:2 - att1 - att2 - att3

person2 - program 2:1 - att1 - att2 - att2

             - program 2:2 - att1 - att2 - att3

If I create a series of list tables, selections don't show attributes per program, just all attributes across many programs that occur within the set bounded by the selected persons.

If I create a chart type = table, I get lost.

Could you please point me in a useful direction, or let me know where a tutorial or reference can be helpful?

Labels (1)
2 Replies
hic
Former Employee
Former Employee

Make a pivot table (chart) with Person as first dimension, Program as second and Concat(distinct Attribute, ',') as Expression

HIC

arjunkrishnan
Partner - Creator II
Partner - Creator II

Make Pivot Table Is Possible To Show The Multi Dimension Table in Dimension Wise