how to open qvw file with latest year selection

[#1]

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

[Nicole-Smith · Accepted solution]

See the attached.

[rajeshvaswani77]

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

[#4]

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

thanks

[Nicole-Smith]

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!)

[#6]

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

great help

thanks a ton

[#7]

thanks rajesh..I got my answer