Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Default selection upon opening in Multi Box

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?

1 Solution

Accepted Solutions
Gysbert_Wassenaar

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*


talk is cheap, supply exceeds demand

View solution in original post

4 Replies
Gysbert_Wassenaar

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*


talk is cheap, supply exceeds demand
alexandros17
Partner - Champion III
Partner - Champion III

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

datanibbler
Champion
Champion

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
Not applicable
Author

Thank you for pointing me in the right direction!

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