topic Re: Weekly Calculation in QlikView

Weekly Calculation

Thu, 04 Dec 2014 19:54:42 GMT

Hi All

I would like to create a list box that shows weekly ranges for the selected Month starting from monday to sunday in a calendar day number format e.g "1-7 Week1", "8-14 Week2"...etc How can I do this?

Re: Weekly Calculation

its_anandrjs — Thu, 04 Dec 2014 20:17:30 GMT

Hi,

Try to write expression in any list box like

=Day(WeekStart(DateField))&'-'&Day(WeekEnd(DateField))&' Week'&Week(DateField)

Or You can create any field in the load script

Load

Day(WeekStart(DateField))&'-'&Day(WeekEnd(DateField))&' Week'&Week(DateField) as WeekAndDayStend,

From Source;

Regards

Anand

Re: Weekly Calculation

Thu, 04 Dec 2014 20:31:16 GMT

Thanks for your reply. I wrote the line of code as you suggested

Day(WeekStart("RE_DAY"))&'-'&Day(WeekEnd("RE_DAY"))&'Week'&Week as WeekAndDay

I get an error "Field not found - <Week>

SQL SELECT *

FROM SORCE"

Re: Re: Weekly Calculation

its_anandrjs — Thu, 04 Dec 2014 20:40:11 GMT

For this write

Day(WeekStart("RE_DAY"))&'-'&Day(WeekEnd("RE_DAY"))&' Week '&Week("RE_DAY") as WeekAndDay

Regards

Anand

Re: Weekly Calculation

Thu, 04 Dec 2014 20:42:22 GMT

Thanks! It works. Now what do I do if I want this in a chonological order? e.g week1- week52

Re: Weekly Calculation

saurabh5 — Thu, 04 Dec 2014 20:48:25 GMT

can u post the code how u derived week...or the script, to know what is causing the error?

Re: Weekly Calculation

its_anandrjs — Thu, 04 Dec 2014 20:51:28 GMT

Then in the list box properties >> Sort >> Sort By >> Select State (Auto Ascending) and Select Load Order (Original)

Re: Weekly Calculation

Thu, 04 Dec 2014 21:07:13 GMT

Hi Anand

Never mind...i managed to figure it out. thanks a lot again for your solution

@Saurabh I'm good now thanks