Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
This should be the eastest to make by creating a pivot table. Have you tried that?