Select last 7 days for a specific sheet

[danielnevitt]

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

[Siva_Sankar]

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

[Gysbert_Wassenaar]

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

[danielnevitt]

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

[Gysbert_Wassenaar · Accepted solution]

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