topic Select Fields in QlikView

Select Fields

Thu, 04 Mar 2010 11:11:46 GMT

Sorry for my english..

i have another problem...

i need to make a macro that select multiple values...

For example in the field month select the month<5 and month =8

set mes = activedocument.fields("Mes").getpossiblevalues

select

case 8

activedocument.fields("Mes").select "<=" & 1 & " and =" & 8

end select

case perfil.Item(0).text

justinasp — Thu, 04 Mar 2010 12:55:13 GMT

Hi,

I guess this is, what you are looking for

sub test()
 ActiveDocument.ClearAll

 Set f = ActiveDocument.Fields("MONTH")
 f.Select "<=5"
 f.ToggleSelect "8"
end sub

Cheers,

Justinas

Thu, 04 Mar 2010 17:36:37 GMT

i have read to use toogleselect or something like this

can someone explain me about this??

Fri, 05 Mar 2010 08:49:48 GMT

but how i works???

what this expression mean??

can i add more f.ToggleSelect "8" to add more selections???

thanks for the help...