Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

How to mix a straight table with a pivot table?

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

3 Replies

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

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?

Not applicable

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

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

spavankumar1980
New Contributor II

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

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.