Discussion Board for collaboration on QlikView Layout & Visualizations.
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.
Go to Solution.
trim(date(TempDate,'WW-YY')) as APP_YEARWEEK
Thanks, this works, though sorting seems to be a problem. I'll work it out.
and your sort suggestion worked as well. Thanks for your help.
Give SubField(wk_yr,'-',2)&SubField(wk_yr,'-',1) as your sort expression to sort asc or desc by week and year