topic Re: Set multiple default values in list box on QlikView V10? in QlikView

Set multiple default values in list box on QlikView V10?

Mon, 12 Dec 2011 13:32:42 GMT

Hi ,

Can any one help me to set multiple default values in list box (Version 10).

For example, I've a field with values of A,B,C,D…I need to be selected A&D as default .

Thanks ,

Gnana

Set multiple default values in list box on QlikView V10

swuehl — Mon, 12 Dec 2011 13:44:24 GMT

Try using an OnOpen trigger in Document properties settings with action Select in field,

Product

as field and

(A|D)

as search string.

Hope this helps,

Stefan

Re: Set multiple default values in list box on QlikView V10?

luciancotea — Mon, 12 Dec 2011 13:46:43 GMT

sub DefaultSelection

set f = ActiveDocument.Fields("FieldName")

set fv = f.GetNoValues 'empty array

fv.Add

fv(0).Text = "A"

fv(0).IsNumeric = false

fv.Add

fv(1).Text = "D"

fv(1).IsNumeric = false

f.SelectValues fv

end sub

Re: Set multiple default values in list box on QlikView V10?

Tue, 13 Dec 2011 05:01:51 GMT

Thank you Stefan & Lucian .. It's working !

Set multiple default values in list box on QlikView V10?

Anonymous — Wed, 02 May 2012 13:43:41 GMT

But Stefan

I have Requirement where i have to select

those customer Whose name Start with 'S'

on selection of a Button 'S'

can u help it out .

Set multiple default values in list box on QlikView V10?

Wed, 02 May 2012 14:01:33 GMT

If you have a button.

Add a action, "Select in Field".

Name the Field in the Field-textbox .

In the Search string- textbox, add S*

If you want all customers that starts with S and all customers that starts with T, you can use Stefans solution...

Add ("S*"|"T*") as the searchstring in the "Select in Field" action.

Re: Set multiple default values in list box on QlikView V10?

Fri, 20 Jun 2014 08:22:19 GMT

Is there any possibility with out macro.