topic Re: Activating listbox automatically in QlikView

Activating listbox automatically

Anonymous — Mon, 19 Sep 2016 13:10:23 GMT

Hi all,

I have a list of timestamps and they are all in a listbox.

Now I want the actual/newest timestamp being activated automatically when going into this worksheet.

Is there a possibility to realise this?

Thank you for your help.

Robert

Re: Activating listbox automatically

Or — Mon, 19 Sep 2016 13:14:07 GMT

Yes there is!

Use the OnActivate sheet trigger. You'll presumably need something like Max(YourTimeStamp) as your value.

Re: Activating listbox automatically

marcus_sommer — Mon, 19 Sep 2016 13:14:44 GMT

You could try it with an action with an OnSheetActivate trigger on this timestamp-field with a condition like:

timestamp(max([timestamp-field]))

- Marcus

Re: Activating listbox automatically

tracysmart — Mon, 19 Sep 2016 13:15:35 GMT

Hi Robert

you can add a Trigger in the Sheet properties. On Activate Sheet - Select in Field (YourFieldname) - Search String will be =Max(TimestampField)

Tracy

Re: Activating listbox automatically

Anonymous — Mon, 19 Sep 2016 14:05:24 GMT

Thank you for helping!

... but this doesn't work.

Is =Max(TimestampField) right?

Re: Activating listbox automatically

Anonymous — Mon, 19 Sep 2016 14:11:08 GMT

Maxstring(TimestampField).

Check with text box whether you are getting same format as you have for the field..

Re: Activating listbox automatically

marcus_sommer — Mon, 19 Sep 2016 14:13:51 GMT

You need to ensure that your TimestampField is really a timestamp respectively numeric - if not it need to bechanged within the script with timestam#(TimestampField, 'YourFormatPattern'). Further you need to format the output from the max-function because their return will be a pure numeric number and not have a string-representation.

- Marcus

Re: Activating listbox automatically

marcus_sommer — Mon, 19 Sep 2016 14:49:11 GMT

I would do further checks with various different timestamp-values to ensure that the alpha-numeric return is really always the max. timestamp.

- Marcus