Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

A table with 2 Dimensions, in a grid/matrix style

Can Qlikview do a table similar to this?

Name v // Day =>MondayTuesdayWednesday...
Albertsum(sales)123456789
Bryan23456789010
Carl345678901234

Thanks.

1 Solution

Accepted Solutions
Partner
Partner

Re: A table with 2 Dimensions, in a grid/matrix style

See attched, is this what you mean?

View solution in original post

5 Replies
mov
Esteemed Contributor III

Re: A table with 2 Dimensions, in a grid/matrix style

It is a QV pivot table with dimensions Name and Day (as columns), and expression sum(sales)

Partner
Partner

Re: A table with 2 Dimensions, in a grid/matrix style

See attched, is this what you mean?

View solution in original post

Not applicable

Re: A table with 2 Dimensions, in a grid/matrix style

How do I set a dimension as a column?  A pivot table will only let me Expand/Collapse groups...

Partner
Partner

Re: A table with 2 Dimensions, in a grid/matrix style

You can click on a column header and pivot it to the top.

Not applicable

Re: A table with 2 Dimensions, in a grid/matrix style

Perfect.  Thank you!