topic Re: Select last 7 days for a specific sheet in QlikView

Select last 7 days for a specific sheet

danielnevitt — Fri, 19 Jul 2013 11:56:36 GMT

Hi,

I am trying to set the trigger actions to automatically select the last 7 contract days when a specific sheet is opened.

Does anyone know how to do this?

CONTRACT_DT is my field name.

Any help will be much appreciated.

Regards,

Daniel

Re: Select last 7 days for a specific sheet

Siva_Sankar — Fri, 19 Jul 2013 12:23:11 GMT

Try the following link, http://community.qlik.com/thread/62392 modify your requirements accordingly. Regards. siva

Re: Select last 7 days for a specific sheet

Gysbert_Wassenaar — Fri, 19 Jul 2013 12:34:10 GMT

Add a Select in Field action to the OnActivate sheet trigger with CONTRACT_DT as field and as search string ='>='&Date(max([CONTRACT_DT],7)). See attached example

Re: Select last 7 days for a specific sheet

danielnevitt — Fri, 19 Jul 2013 12:53:18 GMT

Thanks Gysbert, this works to show me anything created greater than 7 days ago.

Is it possible to create something similar to show between 7 days ago and today?

This might be a stupid question, but does Qlikview know the code '&Date' is today?

Thanks,

Daniel

Re: Select last 7 days for a specific sheet

Gysbert_Wassenaar — Fri, 19 Jul 2013 14:13:12 GMT

Something like this: ='>='&Date(today()-7)&'<='&Date(today())