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

Maximized Date should be selected when data reloads

Hi all,

I have creaeted a report in that i was generating the pdf automatically and sending mail to the respective people .when the job is refreshed the data changes so that i need to select the maximum date of that list box. can u help me how to make the current selection as the max of date.

1 Solution

Accepted Solutions
jagan
Partner - Champion III
Partner - Champion III

Hi,

Please do the following

Settings Menu -> Document Properties -> On Post Reload -> Add Actions -> Add -> Select -> Select in Field

Now give Field Name and Search string as =Max(DateFieldName)

Hope this helps you.

Regards,

Jagan.

View solution in original post

4 Replies
jagan
Partner - Champion III
Partner - Champion III

Hi,

Please do the following

Settings Menu -> Document Properties -> On Post Reload -> Add Actions -> Add -> Select -> Select in Field

Now give Field Name and Search string as =Max(DateFieldName)

Hope this helps you.

Regards,

Jagan.

Not applicable
Author

field name and data field name is same name right?

jagan
Partner - Champion III
Partner - Champion III

Hi,

Yes, Field Name and DateFieldName are one and the same.

Regards,

Jagan.

Not applicable
Author

Hi,

i did it but when i refresh through qemc i am not getting the value selected.........