topic Re: WEEK Function in QlikView

WEEK Function

Thu, 31 Jul 2014 17:39:19 GMT

I have date field YYYYWK format,I want to get WeekNumber,will Week function help here??

LOAD * INLINE [

YEARWEEK

201315

201318

201325

201402

201415

];

I want

WEEK

Thanks

Re: WEEK Function

its_anandrjs — Thu, 31 Jul 2014 17:42:45 GMT

Try with

LOAD YEARWEEK, Right(YEARWEEK,2) as Week;

LOAD * INLINE [

YEARWEEK

201315

201318

201325

201402

201415

];

Re: WEEK Function

Thu, 31 Jul 2014 17:53:02 GMT

Thanks..its fine...but in above Inline Table we have 15th week for both Years.

I want to show week Values in Y Axis like below,How we can do it

--------------------------------------------Y

15 18 25 02 15

Thanks

Re: WEEK Function

joshabbott — Thu, 31 Jul 2014 18:06:00 GMT

I'm assuming you aren't loading from an inline table? Try:

Right(YEARWEEK,2) as WeekOfYear

Re: WEEK Function

Thu, 31 Jul 2014 18:09:50 GMT

yes I am loading it from Database,

I would like to get

WEEK Values like WK15,WK18,WK25,WK02,WK15..

Thanks

Re: WEEK Function

its_anandrjs — Thu, 31 Jul 2014 18:11:56 GMT

In your table if week is for all years then you get week for all years other wise you can use the master calendar.

and for week like this way 15 18 25 02 15

You can achieve this by using the pivot table and add the dimension week and then click on the week dimension and drag it to the right hand side upper top corner of the chart then you get week like you ask.

See the attached pivot sample