topic Re: pivot table chart - title in QlikView

pivot table chart - title

Tue, 21 Jan 2014 23:08:39 GMT

I have created a pivot table chart title, to display the filters selected.

But when I export the pivot table to Excel, how can I make the title show in the report?

or do you have any other ideas. All the filters are not part of the pivot table chart display. Therefore, when a filter is applied I created an expression in the chart title to display the filters seleted. It works great, but when exporting to excel this title which includes the filters applied, does not show.

Re: pivot table chart - title

stevedark — Tue, 21 Jan 2014 23:19:53 GMT

When exporting to Excel using the standard function it is not possible to send the caption also.

You could add an expression to your table, and show the selections on the first row only, by using the RowNo function:

=if(rowno(total) = '1', $(Selections), null())

This will look a bit odd on screen though.

If you search QlikCommunity you will find a number of examples of how you can write output to Excel using a Macro, this will then allow you to use VBScript to write the Selections to a cell in Excel before inserting the data.

If you use Print rather than Export then the ability to include selections is included.

You could use a third party tool for sending data to Excel. The one I recommend is called NPrinting, and this allows you to send data to a pre-defined Excel template, into which you could also write the current selections.

Please get in touch with me if you would like more information on NPrinting.

- Steve

Quick Intelligence

Re: pivot table chart - title

iktrayanov — Wed, 22 Jan 2014 00:17:07 GMT

First of all stop exporting to Excel.

one option you can try is instead of the caption put your current selection in the total label for the first dimension

Regards,

Ivan

Re: pivot table chart - title

Wed, 22 Jan 2014 19:12:42 GMT

Thank you Ivan Trayanov for taking time to respond and for your willingness to share your knowledge.

Re: pivot table chart - title

Wed, 22 Jan 2014 19:14:31 GMT

thank you Steve Dark for taking time to respond and for your willingness to share your knowledge. I will certainly try out your option too.

Re: pivot table chart - title

Sun, 29 Jun 2014 14:10:15 GMT

How to set the title in VBScript macro ?