[POC] Dynamic columns + custom table shape

Thu, 09 Jun 2011 15:40:41 GMT

Hi everyone,

I am looking for a proof of concept, and for pointers that could help me find a way to build a particular table, using QV10.

Could an experienced QV user look at the following table, and tell me if it is something feasable?

Please note that :

- The number of columns is entirely dynamic and depends on the number of rows into a database table

- The last two columns of the array are the same whatever the database table contains (they are subtotals and totals)

- The labels of the rows are "hard coded" (at the left end of the table), the content of the table comes from calculations (sums of fields)

- As you might see on the screenshot, it's a kind of "pivot table", including vertical and horizontal "groups"

(I am sorry, I had to hide the name of the fields - it's corporate related and cannot be disclosed)

Could someone tell me if it is something feasable under qlikview? I don't manage to come up with a way to have static rows and dynamic columns. And I don't manage to build that particular "groups" (the first two columns of the table on the left).

I am happy with every pointers that could be helpful (pages of manuals, videos, articles, advices..)

Thank you in advance,

Julian

[POC] Dynamic columns + custom table shape

Anonymous — Wed, 15 Jun 2011 13:48:08 GMT

This should be the eastest to make by creating a pivot table. Have you tried that?

topic [POC] Dynamic columns + custom table shape in QlikView

[POC] Dynamic columns + custom table shape

[POC] Dynamic columns + custom table shape