topic Automatic selection from first day of the current year until yesterday in QlikView

Automatic selection from first day of the current year until yesterday

dimak123 — Thu, 12 Mar 2015 11:52:18 GMT

Hi to all,

I am looking for a way to make Automatic selection from first day of the current year until yesterday , every time when the model is opening

thanks a head for the help

Re: Automatic selection from first day of the current year until yesterday

Gysbert_Wassenaar — Thu, 12 Mar 2015 11:58:22 GMT

Add a Select in Field action to the OnOpen document trigger on the Triggers tab of the Document Properties window. The search string you need is something like: ='>=' & YearStart(Today()) & '<=' & Today()-1

Re: Automatic selection from first day of the current year until yesterday

Anonymous — Thu, 12 Mar 2015 12:07:53 GMT

You can add a document trigger for this. Document Properties>> Triggers >> onOpen >> Add Actions >> Select in Field

Give your field name and below expression in the search string

='>=' & YearStart(today()) & '<=' & date(today()-1)

Re: Automatic selection from first day of the current year until yesterday

dimak123 — Thu, 12 Mar 2015 12:45:45 GMT

thanks to all