Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Today and next working day

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

A

1 Solution

Accepted Solutions
MVP
MVP

Re: Today and next working day

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

4 Replies
MVP
MVP

Re: Today and next working day

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

Not applicable

Re: Today and next working day

Swuehl

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

Thanks yet again

A

Not applicable

Re: Today and next working day

Ignore me

date(SpotDate)

Thanks

MVP
MVP

Re: Today and next working day

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

e.g.

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

Community Browser