topic Re: Weeks Functionality in QlikView

Weeks Functionality

Sun, 07 Dec 2014 15:18:06 GMT

I have a list box containing "Weeks" which I used the script:

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

It shows weeks from 1 to 52

How can I make it to show Week1 to Week4 or Week5 for every month? and how can I remove the "- Week" text in the list box?

Re: Weeks Functionality

its_anandrjs — Sun, 07 Dec 2014 18:03:15 GMT

Hi,

It seems there is some null values in the date field thats why you get - n the Week field. That why you get nothing in the week field you can check in the "RE_DAY" field.

You can try also

=If( Len(Day(WeekStart("RE_DAY"))) >0, Day(WeekStart("RE_DAY")) ) &'-'&
If( Len(Day(WeekEnd("RE_DAY"))) > 0, Day(WeekEnd("RE_DAY"))) &' Week'& Week("RE_DAY") as Weks

But i recommend check the RE_DAY field for null values.

Regards

Anand

Re: Weeks Functionality

Sun, 07 Dec 2014 18:43:06 GMT

Hi Anand

Thanks for your rep;ly. The RE_DAY field does indeed contain NULL values, so it makes sense now.

I applied your script and I still get weeks in (1-52). I think the "Week" function is not an option here as I would like to see every month's weeks as Week1, Week2, Week3, Week4. Is there any fuction that can give me that?

Re: Weeks Functionality

Anonymous — Sun, 07 Dec 2014 18:50:38 GMT

A quick search found this :

'Week'&Ceil(Day(Date)/7) as MonthlyWeek

from Month Week ( 1 to 4 or 5 weeks)

Re: Weeks Functionality

Sun, 07 Dec 2014 19:02:40 GMT

Thanks Bill , That works perfectly. Thank you too Anand

Re: Weeks Functionality

its_anandrjs — Sun, 07 Dec 2014 19:11:42 GMT

Hi,

You can try this way also

'Week'&Ceil(Day("RE_DAY")/7) &' - '&Month("RE_DAY") as MonthlyWeekField

Regards

Anand

Re: Weeks Functionality

Sun, 07 Dec 2014 19:12:46 GMT

I'm getting duplicates for some dates with different week numbers

Any idea why I'm getting this?

Re: Weeks Functionality

anbu1984 — Mon, 08 Dec 2014 05:57:33 GMT

Can you post sample app