topic Re: Need help on dates in QlikView

Need help on dates

Tue, 03 Feb 2015 14:01:50 GMT

Hi All

Need to generate Periods for date field by taking each period as 2 weeks

[like

1,2 ---> P1

3,4 ---> P2

5,6----> P3

7,8 ---> P4

9,10 ----> P5

11,12 ----> P6

13,14----> P7

15,16---> P8

]

Regards

John

Re: Need help on dates

jpenuliar — Tue, 03 Feb 2015 14:12:15 GMT

Have a look a Mapping Load Techniques

Re: Need help on dates

jpenuliar — Tue, 03 Feb 2015 14:16:05 GMT

http://www.quickintelligence.co.uk/applymap-is-it-so-wrong/

attached a tutorial link

Re: Need help on dates

rubenmarin — Tue, 03 Feb 2015 14:19:16 GMT

Hi John, quick answer will be:

create a field like: Ceil(Week(DateField)/2) & 'P'

but for some dates like '01/01/2012' it will return 26 (as 01/01/2012 is part of the week 52 of 2011)

If you want to start like 01/01/year will be always in week 1, you can use:

Ceil(Floor(DayNumberOfYear(DateField) + WeekDay(YearStart(DateField))/7)/2) & 'P'

Re: Need help on dates

Anonymous — Tue, 03 Feb 2015 14:28:02 GMT

Hi,

you can have a more column in your table called WEEK

then load a inline with two column WEEK and Period assign values like below

and use Period for rest of the calculation

LFET JOIN(DATE_TABLE) //(your table)

PERIOD:

LOAD * INLINE [

WEEK,PERIOD

1, P1

2, P1

3, P2

4, P2

5, P3

6, P3

7, P4

8, P4

9, P5

10, P5

11, P6

12, P6

13, P7

14, P7

15, P8

16, P8

];

Re: Need help on dates

Anonymous — Wed, 04 Feb 2015 08:35:43 GMT

Is your problem resolved ??

Re: Need help on dates

Anonymous — Wed, 04 Feb 2015 08:47:07 GMT

Use if Condition

If(Week>=1 and Week <2 ,'P1',

If(Week>=3 and Week <4 ,'P2'))

Like this

u can use the inline table or use the interval match function..........

Re: Need help on dates

Wed, 04 Feb 2015 18:17:16 GMT

Not yet i am working on that