Printing caption/header from pivot table

[#1]

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.

[bradshields]

Also looking for this. any ideas from anyone?

[#3]

^^ 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)

[#4]

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!

[#5]

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.

[#6]

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.

[#7]

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.

[advait_thakur]

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

[#9]

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.

[#10]

Hi Kevin,

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

1. Open Variable explorer (CTRL+ALT+V) and create a new variable. This will be your "chart header" variable. Let's call it vHeader.
2. Select vHeader and define it as My Chart Header
3. Click OK to close the Variable Explorer
4. Open the properties of your chart. In the Title put =vHeader
5. Create a text box and open the properties.
6. For the text enter =vHeader
7. 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).