Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Week/Year for X-Axis

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.

3-4-2013 3-34-09 PM.png

Document format is

3-4-2013 3-36-43 PM.png

What am I missing?

thanks in advance.

Jim

Tags (2)
1 Solution

Accepted Solutions
sivarajs
Valued Contributor II

Re: Week/Year for X-Axis

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

4 Replies
sivarajs
Valued Contributor II

Re: Week/Year for X-Axis

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

Not applicable

Re: Week/Year for X-Axis

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

Not applicable

Re: Week/Year for X-Axis

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

sivarajs
Valued Contributor II

Re: Week/Year for X-Axis

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

Community Browser