Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello QlikView..
i need a help.
i have a chart that show values of weeks per year.
Dimension is [Year]-[Week] (ex. 2013-41), expression is sum(Value)
But my first week (2013-1) is appended by last date of desember (2013-1) that owned by 2014-1.
How to separate it and keep it show on my chart when i select 2013?
And also when i select 2014, it still show full 2013-1 that included last date of december?
thx
There is a difference between Year(date) and WeekYear(date). For example, for 2013-12-30 you have the following:
Year(date) = 2013
WeekYear(date) = 2014 - since the day belongs to week 1 of 2014.
As dimension you should most likely use a field based on WeekYear(), e.g.
WeekYear(date) & '-' & Week(date)
but for the selection, you should use a field based on Year(), e.g.
Year(date) as Year
HIC
hello Henric,
thx for your help.
I've tried that just now, and the issue for last date is solve..but when i click year 2014, in my chart there's no the first week (2014-1) ..
How to solve that?
thx
Hi,
I acknowledge that prob you have..
But I would advise you to build your week no as Year(Date)&' '&Ceil(RowNo()/7) as WeekNo.
This should work.. Try n lemme know..
Thanks,
Prabhu
i try to create field WeekYearCal with weekyear(Date).
and i use set analysis {<WeekYearCal={"$(=max(Year))"}, Year=>}
And now i can see full week of year each week.
But my 2014-1 doesn't show when i select year 2013, it only shows in year 2014 and append to 2014-1 in 2014.
How to keep it show with full first week and still show first next year week in my current year chart? without split the data.
many thx