Solved: Using Variables in Report Headers - QV11. Is it po... - Qlik Community

ngulliver · ‎2012-04-23

I have a quick question:

I know that QV isn't really a reporting tool but I have a QV11 project with report heavy requirements. I would like to know if it is possible to use variables in the header or footer of reports and if so, how ?

Many thanks.

Report Inappropriate Content · ‎2013-05-02

Hi together,

using QlikView variables in the header / footer section of a report is quite easy:

just put '=<name of variable>' in the proper section of the report properties

If you're using VBA macros you can manipulate your variable (in the example above it is named 'vHeading') with the following command:

ActiveDocument.Variables("vHeading").SetContent "my desired variable value to be shown in report header" true

View solution in original post

Report Inappropriate Content · ‎2012-07-24

I'd like to know how to do this as well, so if anyone's got a method, I'd appreciate it.

Report Inappropriate Content · ‎2013-05-02

Hi together,

using QlikView variables in the header / footer section of a report is quite easy:

just put '=<name of variable>' in the proper section of the report properties

If you're using VBA macros you can manipulate your variable (in the example above it is named 'vHeading') with the following command:

ActiveDocument.Variables("vHeading").SetContent "my desired variable value to be shown in report header" true

Using Variables in Report Headers - QV11. Is it possible ?