topic Select max value in list box by default in QlikView

Select max value in list box by default

Tue, 27 Jan 2015 12:56:39 GMT

Hi,

I have a problem of getting the max date selected in a list box. I am not sure how this needs to be done. Greatly appreciate any advice.

Thanks,

Gayan.

Re: Select max value in list box by default

Gysbert_Wassenaar — Tue, 27 Jan 2015 12:59:16 GMT

Why does it need to be done? What's the problem with letting the user decide which date should be selected? Sort the date listbox in descending order if necessary to let the user easily select the maximum date.

Re: Select max value in list box by default

Tue, 27 Jan 2015 13:03:04 GMT

Hi Gysbert,

The reason being I need to keep the most recent date selected by default so that the users when opening the document will first see the most recent details and if needed can select previous dates.

Hope this helps.

Gayan.

Re: Select max value in list box by default

Gysbert_Wassenaar — Tue, 27 Jan 2015 13:19:13 GMT

You can try using the OnOpen document trigger.

Re: Select max value in list box by default

Tue, 27 Jan 2015 13:41:22 GMT

Thanks Gysbert,

Is it the 'select in field' action we need to use?

Re: Select max value in list box by default

Gysbert_Wassenaar — Tue, 27 Jan 2015 13:45:37 GMT

Yes

Re: Select max value in list box by default

MarcoWedel — Tue, 27 Jan 2015 13:47:12 GMT

Hi,

maybe this helps:

http://community.qlik.com/message/635453#635453

regards

Marco

Re: Select max value in list box by default

Tue, 27 Jan 2015 14:08:22 GMT

Thanks Gysbert and Marco for the illustration. I tried adding the action but on the reload, I cannot get the list box to highlight the max date. Is it something I've missed? The list box controller has the 'census_time' assigned. I have attached the screenshot of the action.

Re: Select max value in list box by default

sunny_talwar — Tue, 27 Jan 2015 14:24:21 GMT

I would create a text box with the same expression (=max({1} census_time) to check if the this is the same format as the format of census_time in the document properties. If the format is different, I would think that the selection won't be made. So you will essentially have to force the format to be the same one by using Date function if census_time is a date.

I hope this helps.

Best,

Re: Select max value in list box by default

Tue, 27 Jan 2015 15:04:53 GMT

Hi,

I have no idea how you data looks like but what happens if you just use the max(census_time) as I assume your users dont have any other selections triggered on document opening?

Re: Select max value in list box by default

Thu, 29 Jan 2015 10:19:37 GMT

Hi All,

Thank you for all the valuable advice given. I don't know if its an issue in my PC or in the qlikview edition as a whole but apparently after setting the onOpen function when I tried opening the page using the 'Open in Server' option, the max date was selected.

Thanks again for the feedback given.