Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

[POC] Dynamic columns + custom table shape

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"

3tab.png

(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

1 Reply
dennisnet
Valued Contributor III

[POC] Dynamic columns + custom table shape

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