Default Listbox Date Value(6 weeks ago)

[#1]

Hello

I am new to Qlikview so forgive me if this is easy.

I know how to set a default value for a listbox as a trigger. What I am struggling to do is set the date in a listbox to 6 weeks prior to the most recent date.

I want the search to be >= Dateadd(week,-1,max(datefield))

i.e. 6 weeks prior to the latest date in the returned rows of data. But Dateadd is not available in Qlikview.

Any suggestions?

[#2]

There's no dateadd() function, you should use:

6 weeks = 42 days

>= max(datefield) - 42

Regards,

Ricardo

[srinivasa1]

Use Weekend or Week Start  function

[#4]

Thank-you Ricardo.

I will try this tomorrow in work.

[#5]

In what context Shri? How would I apply either of these?

[srinivasa1]

Create date island. with min date and max( date)-42 .you just create calendar date for last 6 week.