Discussion board where members can get started with QlikView.
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?
Go to Solution.
If (Date = today() or Date = LastWorkDate(today(),2), Date, NULL() ) as SpotDate
You've helped me out loads , can you advise how to format as DD/MM/YYYY
Thanks yet again
If (Date = today() or Date = LastWorkDate(today(),2), Date(Date,'DD/MM/YYYY'), NULL() ) as SpotDate