topic Pivot table in Report in QlikView

Pivot table in Report

marco_puccetti — Thu, 23 Apr 2015 08:43:59 GMT

Hello, i need to insert in a report a pivot table, but i have noticed that is not possible to set the height and the column to be displayed.

If i insert the table, it is not showed properly and the field are too small.

How can i solve this, in order to show a table in an optimal format to print without modifying the table outside the report?

Thanks

Marco

Re: Pivot table in Report

marcus_sommer — Thu, 23 Apr 2015 10:39:39 GMT

In the report-editor you could try to change the object-properties (original, maximize ..) and use the tab position for sizing and position (drag'n drop is awful). But often you could only achieve a passable report if you used special report-objects (in a hidden sheet) which looks awful within the sheet but work in the report.

- Marcus

Re: Pivot table in Report

marco_puccetti — Thu, 23 Apr 2015 12:34:55 GMT

Thanks

Marco

Re: Pivot table in Report

marco_puccetti — Thu, 23 Apr 2015 13:35:20 GMT

Another question, to add a generic table to a report is only necessary to drag and drop it in the report, but when i do this, something wrong appens:

The table remains in the black rectangle of the white space.

What can i do?

Thanks

Marco

Re: Pivot table in Report

marcus_sommer — Thu, 23 Apr 2015 14:10:12 GMT

This meant that the table-content with the place-holder from report didn't fit well. I think you will need to select your data so that they fit to the space from place-holder.

If you want to show more data you have to increase this place-holder and/or you used a report with multi-page data-sheets and/or you used a selection-loop through certain fields (option in report-properties).

- Marcus

Re: Pivot table in Report

marco_puccetti — Thu, 23 Apr 2015 14:40:01 GMT

I have used the same drag and drop method for an other table with more data, but the table has been inserted with a subset of data instead.

What do you intend for selection loop?

Marco

Re: Pivot table in Report

marcus_sommer — Thu, 23 Apr 2015 15:18:37 GMT

You could loop through a field like area or categorie and for each possible field-value will be created an own report. This meant you will be able to use a report-structure with one or two reports with high consolidated data and then many reports on a more detailed level.

But if you have to create many reports you should have a look on tools like NPrinting which provide more quality and are easier to use but it won't be for free.

- Marcus

Re: Pivot table in Report

marco_puccetti — Fri, 24 Apr 2015 08:23:27 GMT

Ok just solved, the black part is the active table so if i enlarge that part it will show the table.

So an other question, if is there a table that has more rows and i need to paginate it, how can i do?

Thanks

Marco

Re: Pivot table in Report

marcus_sommer — Fri, 24 Apr 2015 08:40:06 GMT

Within the report-properties there is a tab header/footer with a lot of options.

- Marcus