topic Week/Year for X-Axis in QlikView

Week/Year for X-Axis

Mon, 04 Mar 2013 20:41:15 GMT

Hi:

Can't seem to find a previous discussion on this. I currently have a variable created in the script to give me YEAR_MONTH

Which works great. Seeking to do the same to add to a Cyclic Group dimension for a series of charts and thought I was home free with this, which loads without error:

date(WeekStart(APPROVED_DATE),'WW-YY')) as APP_YEARWEEK

But the resulting field shows me, which looks right except for the 00.

Document format is

What am I missing?

thanks in advance.

Jim

Re: Week/Year for X-Axis

sivarajs — Tue, 05 Mar 2013 05:16:21 GMT

trim(date(TempDate,'WW-YY')) as APP_YEARWEEK

Re: Week/Year for X-Axis

Tue, 05 Mar 2013 13:57:05 GMT

Thanks, this works, though sorting seems to be a problem. I'll work it out.

Re: Week/Year for X-Axis

Wed, 06 Mar 2013 19:30:28 GMT

and your sort suggestion worked as well. Thanks for your help.

Re: Week/Year for X-Axis

sivarajs — Thu, 07 Mar 2013 11:35:24 GMT

Give SubField(wk_yr,'-',2)&SubField(wk_yr,'-',1) as your sort expression to sort asc or desc by week and year