Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
s10157754
Creator III
Creator III

Dynamic Report Header

Dear Qlikview Experts,

I had came across a situation whereby I was unable to have dynamic report header.

My intention is to have one week date period appearing on the top left hand side of the report.

E.g. Period of Performance: 06/02/2018 ~ 12/02/2018

Capture.PNG

I had tried to write the expression in report setting like the expression below but it does not work.

=Date(Max(Date)-7) & ' ' & '~' & ' ' & Date(Max(Date)-1)

I had also tried to create variable and put inside the report header. However it also does not work.

Any ideas from you all would be greatly appreciated! Thank you for your help in advance!

Best Regards

1 Solution

Accepted Solutions
shiveshsingh
Master
Master

Try this

=date(num (max((date(date#(Date,'DD/MM/YYYY'),'MM/DD/YYYY'))))-7) & ' ' & '~' & ' ' & date(num (max((date(date#(Date,'DD/MM/YYYY'),'MM/DD/YYYY'))))-1)

View solution in original post

3 Replies
shiveshsingh
Master
Master

Try this

=date(num (max((date(date#(Date,'DD/MM/YYYY'),'MM/DD/YYYY'))))-7) & ' ' & '~' & ' ' & date(num (max((date(date#(Date,'DD/MM/YYYY'),'MM/DD/YYYY'))))-1)

View solution in original post

s10157754
Creator III
Creator III

Hi Shivesh,

Thank you so much for your help! It works like a charm!

Best Regards

shiveshsingh
Master
Master

Glad to know it works

Cheers!