topic Re: Day Name display in QlikView

Day Name display

Thu, 17 Apr 2014 17:55:29 GMT

Hi, I want use Dayname(today()) to display Thursday, friday like.... But not getting the right forumula. Thanks,

Re: Day Name display

its_anandrjs — Thu, 17 Apr 2014 18:04:33 GMT

Change your SET variables like

SET DayNames='Monday;Tuesday;Wednesday;Thursday;Friday;Saturday;Sunday';

Then in text box write

=WeekDay(today( ) ) this gives Thrusday

Re: Day Name display

cfz — Thu, 17 Apr 2014 18:07:26 GMT

HI Madu,

Use

WeekDay(Today())

instead.

I hope it helps,

Carlos

Re: Day Name display

Thu, 17 Apr 2014 18:11:01 GMT

weekday(today()) will work for you

Re: Day Name display

Thu, 17 Apr 2014 18:18:31 GMT

=WeekDay(Today())&', '&num(weekday(Today()))&' '&month(Today())&' '&year(today()) Output is Thursday, 3 Apr 2014 I am missing like 3rd, 4th, 5th, 2nd like?? Thanks,

Re: Day Name display

its_anandrjs — Thu, 17 Apr 2014 18:21:01 GMT

Hi,

But Weekday(today( ) ) will not give exactly Thrusday please check if i am wrong

It gives

Weekday(today( ) ) Thu instead of Thrusday

Re: Day Name display

Thu, 17 Apr 2014 18:26:10 GMT

I used this SET DayNames='Monday;Tuesday;Wednesday;Thursday;Friday;Satday;Sunday'; So I get Thursday