topic Re: Maximum Week When Open Tab in QlikView

Maximum Week When Open Tab

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

How do I code so that the maximum week (starting on Mon) is selected when a tab is selected. I have the following fields:

PostDate: date posted

WeekSort: numeric value for the week

StartofWorkWeek: Has the format of "Mon - 03/12/18". It is sorted using Week Sort

I tried the following in the Trigger tab of Properties for the tab without success:

Action=Select in Field

Search String: ='=date(max(WeekSort))'

Field: Weeksort

Re: Maximum Week When Open Tab

ychaitanya — Thu, 22 Mar 2018 20:08:44 GMT

Your WeekSort has numeric values, why are you converting to Date in the Trigger Actions ?

You could just use Max(WeekSort)

Re: Maximum Week When Open Tab

Anonymous — Thu, 22 Mar 2018 20:16:06 GMT

Is this the right syntax:

='=max(WeekSort)'

I am getting all Weeksort selected when I do this.

Re: Maximum Week When Open Tab

ychaitanya — Thu, 22 Mar 2018 20:21:32 GMT

=Max(WeekSort)

Re: Maximum Week When Open Tab

MarcoWedel — Thu, 22 Mar 2018 20:48:29 GMT

Hi,

one example using only the StartofWorkWeek field loaded as Dual value (i.e. not only text):

tabCalendar: 
LOAD *, 
    Date(WeekStart(Date),'WWW - MM/DD/YY') as StartofWorkWeek;   
LOAD Date(MinDate+IterNo()-1) as Date 
While MinDate+IterNo()-1 < MaxDate; 
LOAD MakeDate(2017,1) as MinDate, 
    MakeDate(2017,6) as MaxDate 
AutoGenerate 1;

hope this helps

regards

Marco