topic Re: Creating a multidimensional table in QlikView

Creating a multidimensional table

Fri, 06 Dec 2013 20:40:05 GMT

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?

Re: Creating a multidimensional table

hic — Fri, 06 Dec 2013 20:45:49 GMT

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

HIC

Re: Creating a multidimensional table

arjunkrishnan — Thu, 03 Apr 2014 08:30:11 GMT

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