topic Re: How to preselect data in listbox in QlikView

How to preselect data in listbox

Anonymous — Wed, 31 Aug 2016 11:33:27 GMT

Hi all,

I'm a very new user of QlikView (24 hours and counting) and need to ask the community a question.

I'm building a dashboard that is specific to a division in our organisation (Division 6 of 6) and I have connected the data from a large Excel sheet that lists entries by the different divisions.

I have a tab with a listbox that reads the necessary column but displays all 6 divisions for selection and I want to have only Division 6 selected. Now, I've looked into the Triggers for the Sheet Properties (which I think is what I'm looking for) but I think my expression is wrong, and that's where I need the help please.

I've added and action on the 'OnActivateSheet' button > chosen 'Select in Field' > added the Object ID (in my instance it is LB02) to the trigger 'Field' and in the 'Search String' box, put ='(Division 6)'

Now, I'm probably way off track but can anyone help?

Thanks in advance

Re: How to preselect data in listbox

Anonymous — Wed, 31 Aug 2016 12:07:54 GMT

Hi Duncan,

On your action put

Field-> Division

Search String -> 6

Reagards!!

Re: How to preselect data in listbox

Anonymous — Wed, 31 Aug 2016 12:50:54 GMT

Hi Manuel,

Thanks for your reply, but it isn't working.

The column header in the Excel sheet is 'Lead Administration' and the entries in that column are listed in the many rows as Division 1, Division 2 etc to Division 6. So in the sheet I'd like Division 6 to only be selected on opening the sheet.

I tried to input into the Field box the column name, as suggested in the Edit Expression dialog box, but that wasn't working so I resorted to putting in the Object ID to see if that worked. In the Search String box I thought I needed to put the exact selection I wanted and as the entry is two words, I thought I'd need to encapsulate that in parentheses.

Thanks.

Re: How to preselect data in listbox

Or — Wed, 31 Aug 2016 12:54:26 GMT

In "Field" use the field name (e.g. Division), rather than the list box's ID. A selection is made in a field for the entire document, not just a specific list box.

Re: How to preselect data in listbox

Anonymous — Wed, 31 Aug 2016 13:39:16 GMT

Aha! I've now gotten it working. I think I was looking at it a little more complex than it actually is.

Thanks all!

Re: How to preselect data in listbox

Anonymous — Thu, 01 Sep 2016 06:04:59 GMT

On field you have to write the field name that you want to select, and on search string the value to select.

Regards!