topic Date Problem in QlikView

Date Problem

ajsjoshua — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I have two calendars Week_UP and Week.

If the user clicks Week_UP=1 then it should show week=1 to week=12.

some what i achieved it but i am facing some difficulties kindly see the attachment.

i am using this expression in list box

=Aggr( Only({<Week = {">=$(=Max(Week_UP)) <=$(=Max(Week_Up)+11)"},Year={$(=Max(Year_UP))} >}WeekOfYear),Week,Year )

ajsjoshua — Fri, 24 Jun 2016 17:34:15 GMT

Hi,

can i use week serial for this.

ajsjoshua — Sat, 25 Jun 2016 04:37:47 GMT

Hi all,

suggest me some ideas

Anonymous — Sat, 25 Jun 2016 08:15:32 GMT

hI,

=Aggr( Only({<Week = {">=$(=Max(Week_UP)) <=$(=Max(Week_Up)+11)"},Year={$(=Max(Year_UP))} >}WeekOfYear),Week,Year )

in your project Max(Year_UP) will give 2015.

try to remove it or please think of it ???