topic Re: Default Listbox Date Value(6 weeks ago) in QlikView

Default Listbox Date Value(6 weeks ago)

Mon, 18 Mar 2013 20:41:06 GMT

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?

Re: Default Listbox Date Value(6 weeks ago)

Mon, 18 Mar 2013 20:46:16 GMT

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

6 weeks = 42 days

>= max(datefield) - 42

Regards,

Ricardo

Re: Default Listbox Date Value(6 weeks ago)

srinivasa1 — Mon, 18 Mar 2013 20:49:10 GMT

Use Weekend or Week Start function

Re: Default Listbox Date Value(6 weeks ago)

Mon, 18 Mar 2013 20:49:36 GMT

Thank-you Ricardo.

I will try this tomorrow in work.

Re: Default Listbox Date Value(6 weeks ago)

Mon, 18 Mar 2013 20:54:27 GMT

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

Re: Default Listbox Date Value(6 weeks ago)

srinivasa1 — Tue, 19 Mar 2013 18:20:06 GMT

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