topic Re: Report in QlikView

Report

upaliwije — Mon, 07 Mar 2016 06:59:59 GMT

Hi,

In my QV document I have copied a report to report editor and in the report heading I want To add Month and Year that the use selects

Eg Income Statement for the Month of (here I want to add ) T_Month and T_Year

Pls advise me how to do it

avinashelite — Mon, 07 Mar 2016 07:06:05 GMT

try like this :

1.Create 2 variables and get the required values of T_Month and T_Year in this variables .

2.Add two text object and add the 2 variables respectively

3.In the report editor simply drag and drop the object to report

Hope this helps you

kaushiknsolanki — Mon, 07 Mar 2016 07:07:35 GMT

Hi,

Functions are not allowed in Header section of the Report.

Instead you can try this.

1. Reduce the margins

2. Then at top or bottom you can place a text box which will have text as below.

='Income Statement for the Month of ' & Month(Today()) &'-'&Year(Today())

Regards,

Kaushik Solanki