Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to select and highlight the lastest date in the listbox by default

Hi everyone,

I am new to qlikview, and met some difficulties recently.

I have a qlikview file, which has many pages, boxes and lists. On each page, there is at least one date list box, so customers could choose the date they want to see.

However, some date list boxes have selected and highlighted the latest date, which is on the top of the list, but some don't.

This is the one that could select and highlight the latest date by default.

1.PNG

Although the title is not the same, actually the "field" is the same with above one. However this one can't select and highlight the latest date by default.

2.PNG

I need to make all the listbox in each page could select and highlight the latest date by default. What should I do?

Thanks!

3 Replies
Anonymous
Not applicable
Author

Hi Bo,

May be trigger feature is the way to go:

Settings - Document Property

Select trigger for "open" document event

Create an associate action

In field set your Date field

In Search chain set =max(Date)

Close and reopen the document to test

Hope this will help you

Best,

MarcoWedel

please post a sample application to demonstrate the problem

regards

Marco

pkelly
Specialist
Specialist

Agree with Maurice, triggers is the way to go...