topic Today and next working day in QlikView

Today and next working day

Fri, 20 Jul 2012 14:28:05 GMT

Hi Guys

Im creating a stacked bar chart and I wish for my demension to be today and tomorrow ( as in the next working day)

I did try and load it as a field in my script - but the weekday part doesnt work ( as its returning null() ) and the format is just the number value of today 41110

if(Date = today() or Date = today(weekday(1)),Date,null()) as Spotdate

Can anyone please help?

Thanks

Re: Today and next working day

swuehl — Fri, 20 Jul 2012 14:37:19 GMT

If (Date = today() or Date = LastWorkDate(today(),2), Date, NULL() ) as SpotDate

Re: Today and next working day

Fri, 20 Jul 2012 14:41:27 GMT

Swuehl

You've helped me out loads , can you advise how to format as DD/MM/YYYY

Thanks yet again

Re: Today and next working day

Fri, 20 Jul 2012 14:47:41 GMT

Ignore me

date(SpotDate)

Thanks

Re: Today and next working day

swuehl — Fri, 20 Jul 2012 14:47:46 GMT

Date(YourDateField,'DD/MM/YYYY')

e.g.

If (Date = today() or Date = LastWorkDate(today(),2), Date(Date,'DD/MM/YYYY'), NULL() ) as SpotDate