Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

robert2012
New Contributor III

Activating listbox automatically

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

1 Solution

Accepted Solutions
praveenavelagap
Contributor III

Re: Activating listbox automatically

Maxstring(TimestampField).

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

7 Replies
Or
Valued Contributor II

Re: Activating listbox automatically

Yes there is!

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

Re: Activating listbox automatically

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

timestamp(max([timestamp-field]))

- Marcus

tracysmart1969
Contributor

Re: Activating listbox automatically

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

robert2012
New Contributor III

Re: Activating listbox automatically

Thank you for helping!

... but this doesn't work.

Is =Max(TimestampField) right?

praveenavelagap
Contributor III

Re: Activating listbox automatically

Maxstring(TimestampField).

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

Re: Activating listbox automatically

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

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

- Marcus

Community Browser