3 Replies Latest reply: Nov 13, 2016 10:44 AM by Seshu S RSS

    How to mix a straight table with a pivot table?

    Rui Esteves

      Hi,

      I am using Qlik Sense Desktop and I need to have a report that mixes a straight table with a pivot table and to look like this:

      Tabela.JPG

      The left part has fixed columns (for reporting proposes I do not want drill-down format), and the right side will have to be dynamic adjusting to the periods that I have movements for each specific project.

      Is there any way to achieve it?

      Thank you,

      Rui

        • Re: How to mix a straight table with a pivot table?
          Sunny Talwar

          What's the issue with just using a pivot table alone? Would you be able to share a sample to try this out in Qlik Sense?

            • Re: How to mix a straight table with a pivot table?
              Rui Esteves

              Sunny,

              TY for your answer.

              A pivot table does not have the left part as a flat table, but as a hierarchical structure which makes more difficult to read with large data sets and easily becomes very large.

              What I am looking for is the compactness of the table format (at the left), associated with the flexibility of the pivot table at the right.

              The example I presented above can be set as:

              LOAD * INLINE [

              Po, item, product, supplier, invoice, date, value

              123, ‘001’, ‘Table 1’, “Supplier 1”, ‘A2016001’, 15012016, 1398

              123, ‘002’, ‘Table 2’, “Supplier 1”, ‘A2016001’, 02022016, 529

              456, ‘001’, “Complete furniture”, “Supplier 2”, ‘95682X’, 13022016, 860

              456, ‘001’, “Complete furniture”, “Supplier 2”, ‘95682X’, 13032016, 860

              456, ‘001’, “Complete furniture”, “Supplier 2”, ‘95682X’, 13042016, 860 ];