topic List Box - Week with Start Date and End Date in QlikView

List Box - Week with Start Date and End Date

bhuprakash — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I want to show the week with their start date and end date in the list box.

Can you please help me to get this done. Below is the format in which i want to show the data.

Re: List Box - Week with Start Date and End Date

Anil_Babu_Samineni — Mon, 18 Dec 2017 11:59:23 GMT

May be use WeekStart() and WeekEnd() functions ??

Re: List Box - Week with Start Date and End Date

martinpohl — Mon, 18 Dec 2017 12:00:23 GMT

edit your script:

Week(DATE(floor([User ActivityCreatedDate]), 'DD-MM-YYYY')) as ACTIVITYWEEK

Week(DATE(floor([User ActivityCreatedDate]), 'DD-MM-YYYY')) &': '&weekstart (DATE(floor([User ActivityCreatedDate]), 'DD-MM-YYYY')) & ' to '& Weekend(DATE(floor([User ActivityCreatedDate]), 'DD-MM-YYYY')) as ACTIVITYWEEK,

regards

Re: List Box - Week with Start Date and End Date

zhadrakas — Mon, 18 Dec 2017 12:04:56 GMT

Expression for list box:

='Week' & ACTIVITYWEEK & ': ' & MakeWeekDate(year(today()),ACTIVITYWEEK) & ' to ' & WeekEnd(MakeWeekDate(year(today()),ACTIVITYWEEK))

you should create a yearWeek Field to get the change over years correctly.

Re: List Box - Week with Start Date and End Date

bhuprakash — Mon, 18 Dec 2017 12:09:51 GMT

Hi Martin,

This is showing exactly i want but if I click on Oct month then it is not selecting all the weeks falls in Oct month.

So this causes of showing incorrect data.

Re: List Box - Week with Start Date and End Date

bhuprakash — Mon, 18 Dec 2017 12:48:10 GMT

when i am selecting Oct month then it is not selecting Weeks falls under Oct month.

Please see the attached file.

Re: List Box - Week with Start Date and End Date

bhuprakash — Mon, 18 Dec 2017 12:57:29 GMT

Sorry.. Checked again.. It is working fine.

Thanks a lot everyone.