Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ajsjoshua
Specialist
Specialist

Date Problem

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 )

3 Replies
ajsjoshua
Specialist
Specialist
Author

Hi,

can i use week serial for this.

ajsjoshua
Specialist
Specialist
Author

Hi all,

suggest me some ideas

galax_allu
Specialist
Specialist

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 ???