Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
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?

Not applicable
Author

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
Contributor II
Contributor II

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.