Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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?

Tags (2)
1 Solution

Accepted Solutions

Re: Default selection upon opening in Multi Box

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
4 Replies

Re: Default selection upon opening in Multi Box

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

Re: Default selection upon opening in Multi Box

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
Esteemed Contributor

Re: Default selection upon opening in Multi Box

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

Re: Default selection upon opening in Multi Box

Thank you for pointing me in the right direction!

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

Community Browser