topic text object auto update in QlikView

text object auto update

Tue, 25 Feb 2014 16:15:06 GMT

I have a text object which reads 'Revenues for WC 17/2/14'

The date displayed is the Monday of the week before, which I have to manually update each week.

How can I get the date part of the text box to automatically update for me each week?

Tue, 25 Feb 2014 16:19:02 GMT

Alex,

With the = sign

= max({1} Date)

Fabrice

Anonymous — Tue, 25 Feb 2014 16:22:41 GMT

Alex

Try this expression in your text box :

='Revenues for WC ' & date(weekstart(today() -7))

Best Regards, Bill

SunilChauhan — Tue, 25 Feb 2014 16:22:51 GMT

='Revenues for '&weekstart(today())

try this hope this helps

Tue, 25 Feb 2014 16:25:14 GMT

perfect, thanks