Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for Data Integration and Data Analytics gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Is is possible to include a field in the Header / Footer of a Report?

I have a Report and would like to include the Date in text format i.e "July 2010". Currently I have to manually update this on a monthly basis.

Ideally I'd like to automate this using the [Date] parameter. The only options for this however format this as a date when what I need is the month in a full text style.

Is this possible? I also have a field in my QVW which holds the date. If I include this in the footer however as [Table.Date] or even &[Table.Date] this just displays this as text without translation into a value.

Can anyone help?

Tags (3)
1 Solution

Accepted Solutions
Highlighted
Not applicable

Is is possible to include a field in the Header / Footer of a Report?

Hi

Put in a = first

=[Table.Date]

Anders

View solution in original post

4 Replies
Highlighted
Not applicable

Is is possible to include a field in the Header / Footer of a Report?

Hi

Put in a = first

=[Table.Date]

Anders

View solution in original post

Highlighted
Not applicable

SV:Is is possible to include a field in the Header / Footer of a Report?

Not sure which date you want in the footer but formatting with full monthname and year is done as follows:

=date(today(),'MMMM-YYYY')


Regards
/Michael





Highlighted
Not applicable

Is is possible to include a field in the Header / Footer of a Report?

Hi Riccardinho,

Did you tried this funtion in the window title.

=MonthName(Today())

Regards,

R.Srinivasan .

Highlighted
Not applicable

Is is possible to include a field in the Header / Footer of a Report?


ansch wrote:
Hi
Put in a = first
=[Table.Date]
Anders
<div></div>


Perfect, thanks Anders!