topic Re: Get Full Day Name in QlikView

Get Full Day Name

rustyfishbones — Sun, 21 Apr 2013 13:46:18 GMT

Hi All,

This is my First Question on the Qlik Community, I am trying to get the full day name like, Monday, Tuesday etc...

If I type the following in a Text Object for Month it works

=DATE(RELOADTIME(),'MMMM') the result is April

However if I try the following for Day

=WEEKDAY(reloadtime()) the result I get is Sun, the result I need is Sunday

Hope you can help

Regards

Alan

Re: Get Full Day Name

jolivares — Sun, 21 Apr 2013 22:48:46 GMT

You have two options: 1st, modify the names of week in your script

SET DayNames='Monday;Tuesday...;

Or make a little table with the inline command containing the days of the week.

Re: Get Full Day Name

sushil353 — Mon, 22 Apr 2013 01:08:20 GMT

Best way is to change the environmental variables

SET DayNames='Monday;Tuesday;Wednesday;Thursdat;Friday;Saturdat;Sunday';

HTH

Sushil

Re: Get Full Day Name

sujeetsingh — Mon, 22 Apr 2013 05:09:12 GMT

yes it is the right approach just put you expression in nested if as

If(exp='Sun',Sunday..like this..you can get it in your expression.

Re: Get Full Day Name

Mon, 22 Apr 2013 05:12:17 GMT

Hi Alan,

Change the below variable in the edit script and use weekday() function

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

Thanks,

Sampath

Re: Get Full Day Name

jagan — Mon, 22 Apr 2013 07:47:50 GMT

Hi Alan,

Try this

=DATE(Today(),'WWWW')

Hope it helps you.

Regards,

Jagan.

Re: Get Full Day Name

rustyfishbones — Mon, 22 Apr 2013 21:49:37 GMT

Hi Jagan,

That's exactly what I was looking for thank you

why is it not 'DDDD' is there a reason for that?

Regards

Alan

Re: Get Full Day Name

jagan — Tue, 23 Apr 2013 06:06:46 GMT

Hi Alan,

I am not sure about DDDD, I think DD is for representing Day number and WWWW is for representing weekday.

Hope this helps you.

Regards,

Jagan.

Re: Get Full Day Name

dagrun — Wed, 26 Aug 2020 09:04:27 GMT

where do i find the edit script?