topic Multi Value select in QlikView

Multi Value select

Tue, 06 Apr 2010 06:43:31 GMT

How can i select muti values in script using "ActiveDocument.Fields("DOB").Select"

set var=ActiveDocument.fields("Month").GetSelectedValues

for i=0 to var.count-1

ActiveDocument.fields("Month").select var.item(0).text

this results only last value from the loop get selected......

i need all the values??? ............

sparur — Tue, 06 Apr 2010 07:03:55 GMT

Hi.

You should use a .ToggleSelect function.

For you example:

set var=ActiveDocument.fields("Month").GetSelectedValues

ActiveDocument.fields("Month").select var.item(0).text

for i=1 to var.count-1

ActiveDocument.fields("Month").ToggleSelect var.item(i).text

next

Tue, 06 Apr 2010 08:20:21 GMT

Thanks lot... for ur immediate reply...