topic Displaying last week date in text object in QlikView

Displaying last week date in text object

Tue, 07 Jul 2015 07:16:33 GMT

Hi Team,

Hope all are doing good.

I have a requirement like in a text object I have to display last week Friday date dynamically. i.e for this week it should be previous week Friday date.( I guess we have to do this with today())

ex:if we see today it should be 03/07/2015

if we see in next week it should be 10/07/15.

Please help on this.

Thanks

Nani.

Re: Displaying last week date in text object

MayilVahanan — Tue, 07 Jul 2015 07:20:53 GMT

Try like this

Date(Floor(WeekEnd(Today()) - 9))

Re: Displaying last week date in text object

Tue, 07 Jul 2015 08:34:36 GMT

Thanks Ramasamy. Its working fine.