topic Re: Dynamic Report Header in QlikView

Dynamic Report Header

s10157754 — Wed, 25 Nov 2020 16:16:04 GMT

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

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

Re: Dynamic Report Header

shiveshsingh — Tue, 13 Feb 2018 06:51:54 GMT

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)

Re: Dynamic Report Header

s10157754 — Tue, 13 Feb 2018 07:04:12 GMT

Hi Shivesh,

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

Best Regards

Re: Dynamic Report Header

shiveshsingh — Tue, 13 Feb 2018 07:10:07 GMT

Glad to know it works

Cheers!