topic Printing caption/header from pivot table in QlikView

Printing caption/header from pivot table

Thu, 21 Jan 2010 15:21:03 GMT

Hi,

been searching the forum and trying different settings but haven't found a solution.

Can't get the caption from tables (charts works) into reports when printing. Not meaning export to excel but print to PDF or paper.

Since I have logic in the captions I don't want to create separate text objects for every table that I want to print. Seems like it shouldn't be a problem 🙂

Using QV SR2.

Printing caption/header from pivot table

bradshields — Thu, 11 Mar 2010 00:55:07 GMT

Also looking for this. any ideas from anyone?

Printing caption/header from pivot table

Thu, 11 Mar 2010 03:26:55 GMT

^^ Me too. This would also apply for the Report Writer, as by default objects (charts) do not display the caption on the page.

(Hi Brad)

Printing caption/header from pivot table

Mon, 27 Sep 2010 12:29:15 GMT

Hi,

Did you find any solution to this problem? I am also experiencing same problem and question from users!

Thanks

p.s. this is my first community post, so hope I have responded in the correct place!

Printing caption/header from pivot table

Fri, 01 Oct 2010 21:39:58 GMT

The best answer I can think of is to declare your chart titles as variables.

This makes them easy to include elsewhere, such as in text boxes or in the header of a report.

SV:Printing caption/header from pivot table

Mon, 04 Oct 2010 23:52:31 GMT

Didn't find a solution. I gave up and created stand-alone text boxes that I placed in the PDF-reports.

Simon's solution might work although I haven't tested it.

Re: Printing caption/header from pivot table

Tue, 24 Jul 2012 20:14:55 GMT

I have tried mightily to find a way to use variables in report headers, to no avail. Perhaps Simon would be more expansive about his technique.

Re: Printing caption/header from pivot table

advait_thakur — Wed, 25 Jul 2012 04:26:54 GMT

Hi,

unfortunately there is no option/choice/alternative available in Qlikview.

Fixing with text box is the only way which i found till now.

How about Macro ?

Thanks,

Advait

Re: Printing caption/header from pivot table

Wed, 25 Jul 2012 06:06:54 GMT

Hi,

we can print chart title along with chart by using print settings in general tab.

goto->general tab->print settings

a dialog box opens

goto->header/footer-> click on tittle button or write &[Title].

please find the screen shots...

hope it helps you.

regards,

Niranjan M.

Re: Printing caption/header from pivot table

Wed, 25 Jul 2012 19:40:23 GMT

Hi Kevin,

I'm afraid the answer might disappoint you, but here is what I did:

Open Variable explorer (CTRL+ALT+V) and create a new variable. This will be your "chart header" variable. Let's call it vHeader.
Select vHeader and define it as My Chart Header
Click OK to close the Variable Explorer
Open the properties of your chart. In the Title put =vHeader
Create a text box and open the properties.
For the text enter =vHeader
Now you can put the text box in your report as a header over your chart. If you ever need to change the title, you only change it in one place (the variable definition).

Re: Printing caption/header from pivot table

Anonymous — Thu, 29 Nov 2012 13:11:20 GMT

Hi Niranjan,

I can only get this to work when printing out an object from the File or the right-click menu when an object has focus. I woud like the same rules to apply when I am printing a report that has the object on it.

Do you know if these Print settings are meant to apply to the printing of of an object within a report as well ?

Thanks,

Jonathan

Re: Printing caption/header from pivot table

qlikmeup — Fri, 19 May 2017 14:31:48 GMT

I can also say, that this doesn't work in a report 😞