Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

how to open qvw file with latest year selection

plz check the qvw file I want to get the year 2010 as the selection whenever I open my qvw file.

Tags (2)
1 Solution

Accepted Solutions

Re: how to open qvw file with latest year selection

See the attached.

6 Replies

Re: how to open qvw file with latest year selection

See the attached.

rajeshvaswani77
Valued Contributor III

Re: how to open qvw file with latest year selection

Hi Sudhanshu,

Go to Document Properties --> Triggers --> On Open --> Edit Actions --> select in field --> Select the field --> Searcgh string use

 

=year(today())

Thanks,

Rajesh Vaswani


Not applicable

Re: how to open qvw file with latest year selection

thanks a lot..this is working...but please let me know what you did exactly.

thanks

Re: how to open qvw file with latest year selection

The way your fields are named matters.  In your load script, you have field named Year.

Document Properties > Triggers >  On Open

Select in Field:

You had: =year

It should just be: Year

     (without the =, and case matters!)

Search String:

You had: =max(year)

Should be: =max(Year)

     (once again, case matters!)

Not applicable

Re: how to open qvw file with latest year selection

thanks a lot...I really appreciate that..

great help

thanks a ton

Not applicable

Re: how to open qvw file with latest year selection

thanks rajesh..I got my answer

Community Browser