4 Replies Latest reply: Mar 13, 2014 7:57 AM by Melissa van Kluyve RSS

    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?