topic Re: Week format in QlikView

Week format

sat_tok52 — Tue, 20 Oct 2015 11:40:54 GMT

Hi Guru's,

I want to display my current week on text object below format,any suggestion please.

Mon 19^th Oct – Sunday 25^th Oct

Thanks,

Satish

Re: Week format

sunny_talwar — Tue, 20 Oct 2015 11:44:02 GMT

May be this:

=WeekDay(WeekStart(Today())) & ' ' & Day(WeekStart(Today())) & 'th ' & Month(WeekStart(Today())) & ' - ' &

WeekDay(WeekEnd(Today())) & ' ' & Day(WeekEnd(Today())) & 'th ' & Month(WeekEnd(Today()))

Re: Week format

rubenmarin — Tue, 20 Oct 2015 11:46:34 GMT

Hi, I don't know how to set the 'th' (the little string version) but for the rest of that:

='Mon ' & Date(WeekStart(Today()), 'DD MMM') & ' - Sunday ' & Date(WeekEnd(Today()), 'DD MMM')

Re: Week format

sunny_talwar — Tue, 20 Oct 2015 11:47:38 GMT

Or this:

=Date(WeekStart(Today()), 'WWW DD') & 'th ' & Month(WeekStart(Today())) & ' - ' &

Date(WeekEnd(Today()), 'WWW DD') & 'th ' & Month(WeekEnd(Today()))

Re: Week format

sunny_talwar — Tue, 20 Oct 2015 11:50:14 GMT

If 'th' is not important, this should also work:

=Date(WeekStart(Today()), 'WWW DD MMM') & ' - ' & Date(WeekEnd(Today()), 'WWW DD MMM')

or WWWW for the whole weekday name

Re: Week format

lucasdavis500 — Wed, 09 Nov 2016 20:26:00 GMT

Hi Sunny, to do this for the previous week, would you just insert "-1" after today()? I tried this, and it didn't seem to change my values, unless I have a syntax error..

=WeekDay(WeekStart(Today()-1)) & ' ' & Day(WeekStart(Today()-1)) & 'th ' & Month(WeekStart(Today()-1)) & ' - ' &

WeekDay(WeekEnd(Today()-1)) & ' ' & Day(WeekEnd(Today()-1)) & 'th ' & Month(WeekEnd(Today()-1))

Re: Week format

sunny_talwar — Wed, 09 Nov 2016 23:26:21 GMT

May be use a comma between Today() and -1

=WeekDay(WeekStart(Today(), -1)) & ' ' & Day(WeekStart(Today(), -1)) & 'th ' & Month(WeekStart(Today(), -1)) & ' - ' &

WeekDay(WeekEnd(Today(), -1)) & ' ' & Day(WeekEnd(Today(), -1)) & 'th ' & Month(WeekEnd(Today(), -1))

Re: Week format

lucasdavis500 — Thu, 10 Nov 2016 17:00:33 GMT

I believe adding "-7" to all of these worked for me

Re: Week format

Anil_Babu_Samineni — Thu, 10 Nov 2016 17:04:32 GMT

Sunny, This scenario do we get "th" as on CAP. If so, Explain me how do we achieve. Once upon a time i got that issue. But, I got one idea for that like images replace like 1, 2, 3, 4 ... 31 Manually. Do we have any other approach to reach that?

Re: Week format

lucasdavis500 — Thu, 10 Nov 2016 17:17:36 GMT

Try using an if statement that determines what day of the month the above functions resolve to..

ex IF(Day(WeekStart(Today())) = 1, 'st', IF(.......)