Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Partner
Partner

Automatic selection from first day of the current year until yesterday

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

1 Solution

Accepted Solutions
Highlighted
greeshma_k
Contributor III

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

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)

View solution in original post

3 Replies
Highlighted
MVP & Luminary
MVP & Luminary

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

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


talk is cheap, supply exceeds demand
Highlighted
greeshma_k
Contributor III

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

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)

View solution in original post

Highlighted
Partner
Partner

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

thanks to all