topic Select last week in QlikView

Select last week

Fri, 24 Sep 2010 09:49:37 GMT

Hi,

I need to automatically select the last Calendar week from my Document to reduce data.

My Field for the Calendar Week is named: cw_iso8601

How can I do this?

Thanks.

Select last week

Fri, 24 Sep 2010 10:17:37 GMT

Hi,

Add a action trigger for OnOpen event under Setting->Document Properties->Triggers "Document Event Triggers" section. Add selection in feild action and for field assign the field name "cw_iso8601" and for search string assign the value =Week(Today()-7) .

Please revert back for any further query in this regard.

Select last week

Fri, 24 Sep 2010 10:20:12 GMT

Hi,

In my previous post I had used "Week(Today()-7)" but you can use maximum transaction data like "Week(Max(Date)-7)"

Select last week

Fri, 24 Sep 2010 10:32:54 GMT

Thank you very much! Its working now 🙂