topic Re: Weekday and Day calc in QlikView

Weekday and Day calc

Wed, 25 Nov 2020 16:16:04 GMT

I am getting Monthyear as below ..how can I manipulate this to get the week, weekday and date also ?

Date(Date#(Trim(SubField(Header, Chr(10), 1)), 'MMM-YY'), 'MMM-YY') as MonthYear,

Thanks much.

Gysbert_Wassenaar — Mon, 29 Aug 2016 15:17:40 GMT

Week(Date#(Trim(SubField(Header, Chr(10), 1)), 'MMM-YY')) as Week,

WeekDay(Date#(Trim(SubField(Header, Chr(10), 1)), 'MMM-YY')) as WeekDay,

Date(Date#(Trim(SubField(Header, Chr(10), 1)), 'MMM-YY'),'DD-MMM-YY') as Date,

vishsaggi — Mon, 29 Aug 2016 15:18:10 GMT

Look here for more information and examples :

Anonymous — Mon, 29 Aug 2016 15:23:26 GMT

you can define additional parameters

D will give you day of month

WWW will give you weekday

WW will give you the weeknumber

but you Need a date in dayformat (means not a month)

e.g. =date('29.08.2016','MM/YYYY D WWW ') gives you