topic Re: Weekday calc in QlikView

Weekday calc

Mon, 16 Apr 2012 09:21:21 GMT

Hi Guys,

I am looking to create a flag in my script that identifies when the date field is equal to "Yesterday"

This is working fine except when its a Monday as Yesterday is then Sunday , ( I wish to identify Friday then !!)

I need to amend the script to a weekday function , but have tried a few different things and cant quite get it , can anyone help

This is formula as it is now :

If(Period_dte = Today() - 1, 'Yes',null()) as YesterdayWH,

Can anyone help ?

Thanks

Jason_Michaelides — Mon, 16 Apr 2012 22:21:38 GMT

Hi,

Try the attached.

Hope this helps,

Jason

Tue, 17 Apr 2012 07:48:40 GMT

Thanks Jason

I had come up with a similar way see attached formula ( as I wanted to create an expression with a null value!!)

Kind regards

if(Period_dte=if(weekday(today()-1) * 1 <5,today()-1,today()-3),'Yes',null()) as YesterdayWH,