topic Re: calendar week with dates from 2 different years in QlikView

calendar week with dates from 2 different years

Wed, 12 Sep 2012 10:13:12 GMT

Hi i have lil problem. I have a chart that always shows all days of a month + days from the previous and following months when the the month start or end was in the middle of a week. for example the 01.03.2012 was a wedensday so i have in my chart also tuesday 28.02.2012 and monday 27.02.2012. ok my set analysis perfect for every month except january and december. I understand the problem but I dont know how to solve it.

ok the problem is:

01.01.2012 was a sunday so in my chart should show 31.12.2011 and so on... but the problem is that qv doesnt understand to take the previous year.

here is the formula:

only({<#Filiale_KBS = , #KW = {'>=$(=Week(MakeDate(#Jahr,#Monat,1)))<=$(=week(MonthEnd(MakeDate(#Jahr,#Monat,1))))'}, #Monat = , FILIALEN_OG.KURZNAME, #LagerNr = , Artikelgruppen.RESSORT= , [Artikelgruppen.U RESSORT] = >}#Datum)

oh and my chart has calendar week and weekday as dimension.

does anyone have an idea how to solve this problem for januaray and december???

regards,

Re: calendar week with dates from 2 different years

Jason_Michaelides — Wed, 12 Sep 2012 10:24:09 GMT

Look at WeekStart() function. I think this will break over years OK.

Hope this helps,

Jason

Re: calendar week with dates from 2 different years

Wed, 12 Sep 2012 10:38:58 GMT

Basicly you are right that weekstart jumps over the years but my problem now is that my chart wont show the date no more here is my formular maybe i did smth wrong (pretty sure i did) but i cant find the mistake.

Only({<#Datum = {'>=$(=WeekStart(MakeDate(#Jahr,#Monat,1)))<=$(=WeekEnd(MonthEnd(MakeDate(#Jahr,#Monat,1))))'}, #Monat = >}#Datum)

Re: calendar week with dates from 2 different years

Jason_Michaelides — Wed, 12 Sep 2012 10:47:30 GMT

Try keeping your expressions simple by pushing what you can back to the script. For example:

WeekStart(MakeDate(#Jahr,#Monat,1)) AS WeekStart

Otherwise please post your app to make it easier to help.

Re: calendar week with dates from 2 different years

Wed, 12 Sep 2012 10:49:53 GMT

#Jahr is the selected year and #Monat the selected month i found my mistake but it is still not showing the days of the previous year

Re: calendar week with dates from 2 different years

Jason_Michaelides — Wed, 12 Sep 2012 10:51:18 GMT

Ah - OK. If you post your app I maybe able to help further. Otherwise it's kind of guesswork.

Re: calendar week with dates from 2 different years

Wed, 12 Sep 2012 10:52:04 GMT

ok I found my mistake. I also had to ignore the year selection. Thanks i appriciate you help