topic Re: Default selection upon opening in Multi Box in QlikView

Default selection upon opening in Multi Box

Mon, 10 Mar 2014 10:29:17 GMT

Hello fellow QlikViewers,

I have a multibox that always has a single value selected for my [AsAt] field. The values are as follows:

AsAt

2013/14-P13 Most Recent Load as at 2014-03-09 20:12

2013/14-P12 As at 2014-03-01 20:10

2013/14-P11 As at 2014-02-01 20:02

2013/14-P10 As at 2014-01-04 20:11

2013/14-P09 As at 2013-12-07 20:18

2013/14-P08 As at 2013-11-09 19:59

2013/14-P07 As at 2013-10-12 18:55

2013/14-P06 As at 2013-09-14 20:04

2013/14-P05 As at 2013-08-17 16:40

2013/14-P04 As at 2013-07-20 20:09

2013/14-P03 As at 2013-06-08 19:58

Within my multi box, I have sort options set to Numeric Value: Descending and Text: Z -> A. This sorts the values appropriately but when opening the dashboard, 2013/14-P03 is always selected. I would like the most recent period, 2013/14-P13 to be selected by default.

I should note my load script pulls AsAt from a QVD file. Both my QVD script and my dashboard script have Document Properties sorting set to the same as the multibox. The data is refreshed nightly.

Any ideas as to how to set the default selection?

Re: Default selection upon opening in Multi Box

Gysbert_Wassenaar — Mon, 10 Mar 2014 10:33:19 GMT

Perhaps sorting by Load Order in descending order will do the trick. Otherwise you'll need to use the OnOpen document trigger and add a Select in Field action to select that last value: *Most*

Re: Default selection upon opening in Multi Box

alexandros17 — Mon, 10 Mar 2014 10:33:27 GMT

With a trigger on the page or in the document (at the end of loading data)

Trigger the selection of a field with the value you need

Re: Default selection upon opening in Multi Box

datanibbler — Mon, 10 Mar 2014 10:37:03 GMT

Hi Melissa,

within the default_selection_wizard (I assume you have a trigger somewhere), you can use a search_expression implementing either

- the FIRSTSORTEDVALUE() fct. or

- the max() fct. (as your most recent value seems to be the largest, numerically)

Test it in a listbox (a search_expression starts with an x, like:

>>> = [value] = max([value]) <<<

HTH

Best regards,

DataNibbler

Re: Default selection upon opening in Multi Box

Thu, 13 Mar 2014 11:57:34 GMT

Thank you for pointing me in the right direction!

=Max({1}[Field]) works nicely as an On Open trigger.