topic Re: Need Help on Creating week buckets in QlikView

Need Help on Creating week buckets

nagarjuna_kotha — Sat, 09 May 2015 08:22:20 GMT

Hi all,

I have one requirement creating week buckets on one field.

What exactly i want is I have one field like DOJ.i wanted to create On that field week buckets i.e in one month we have max 4 or 5 weeks it consist like wise i want week buckets for enataire Year and i should show on line chart.Kindly help me on this with your vallid solutions.

Here i m sharing Sample Data also.

Note : I Need Script Level

Its Urgent>>>>>>>>

Re: Need Help on Creating week buckets

preminqlik — Sat, 09 May 2015 08:43:37 GMT

hey try this

Load *,

if(match(Day(DOJ),1,2,3,4,5,6,7),'Week1',

if(match(Day(DOJ),8,9,10,11,12,13,14),'Week2',

if(match(Day(DOJ),15,16,17,18,19,20,21),'Week3','Week4'))) as Week

from Emp.xls

Re: Need Help on Creating week buckets

MarcoWedel — Sat, 09 May 2015 08:47:17 GMT

Week(DOJ) as Week

WeekName(DOJ) as WeekName

Re: Need Help on Creating week buckets

MK_QSL — Sat, 09 May 2015 08:53:16 GMT

=WeekYear(Today()) &'-'& NUM(Week(Today()) ,'00')

Use DOJ instead of Today()

Re: Need Help on Creating week buckets

nagarjuna_kotha — Sat, 09 May 2015 09:07:12 GMT

Hi Prem,

As per your solution,

Week1>> 1-7,

Week2>> 8-14,

Week3>>14-21,

Week4>> 22-28,

Week5>> ??

Week5>> 29-31 Should be also there right.

Why because some months consist 30 ans some 31.

Any one help me on this...

Re: Need Help on Creating week buckets

preminqlik — Sat, 09 May 2015 10:05:48 GMT

yeah you can make it further like below

if(match(Day(DOJ),1,2,3,4,5,6,7),'Week1',

if(match(Day(DOJ),8,9,10,11,12,13,14),'Week2',

if(match(Day(DOJ),15,16,17,18,19,20,21),'Week3',

if(if(match(Day(DOJ),22,23,24,25,26,27,28),'Week4','Week5'))) ) as Week

Re: Need Help on Creating week buckets

nagarjuna_kotha — Sat, 09 May 2015 10:17:57 GMT

Let me creak whether its fulfilling my requirement or not ?

Re: Need Help on Creating week buckets

nagarjuna_kotha — Mon, 11 May 2015 07:47:05 GMT

Can we create in Front End ?

Let me know.