Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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.

1 Solution

Accepted Solutions
Nicole-Smith

See the attached.

View solution in original post

6 Replies
Nicole-Smith

See the attached.

rajeshvaswani77
Specialist III
Specialist III

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
Author

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

Not applicable
Author

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

great help

thanks a ton

Not applicable
Author

thanks rajesh..I got my answer