topic How to mix a straight table with a pivot table? in App Development

How to mix a straight table with a pivot table?

Tue, 13 Sep 2016 17:25:41 GMT

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:

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 — Tue, 13 Sep 2016 19:22:10 GMT

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?

Thu, 10 Nov 2016 12:45:30 GMT

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 ];

Re: How to mix a straight table with a pivot table?

spavankumar1980 — Sun, 13 Nov 2016 15:44:15 GMT

Just a thought , use Pivot table and in the properties for the pivot table -> presentation -> Uncheck the Indent rows.. That will give the structure you are looking for.