topic Find specific dates in the past in QlikView

Find specific dates in the past

Wed, 04 Jun 2014 09:22:52 GMT

Hi all,

Just a quick one about dates. Has anyone ever dealt with finding weekly dates automatically? I am looking to save in a variable last Friday's date for example.

Thanks

Re: Find specific dates in the past

kiranmanoharrode — Wed, 04 Jun 2014 09:30:46 GMT

use this expression,

It will give u last Friday's Date

=if(WeekDay(Today())='Mon',Date(Today()-3),

if(WeekDay(Today())='Tue',Date(Today()-4),

if(WeekDay(Today())='Wed',Date(Today()-5),

if(WeekDay(Today())='Thu',Date(Today()-6),

if(WeekDay(Today())='Fri',Date(Today()-7),

if(WeekDay(Today())='Sat',Date(Today()-8),

if(WeekDay(Today())='Sun',Date(Today()-9))))))))

Re: Find specific dates in the past

Wed, 04 Jun 2014 09:35:12 GMT

Thanks I wrote something similar myself but rushed to also ask

Re: Find specific dates in the past

kiranmanoharrode — Wed, 04 Jun 2014 09:41:15 GMT

Welcome Joseph...........