Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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