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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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?

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