Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Select Fields

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







1 Solution

Accepted Solutions
justinasp
Creator
Creator

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

View solution in original post

3 Replies
justinasp
Creator
Creator

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

Not applicable
Author

i have read to use toogleselect or something like this

can someone explain me about this??

Not applicable
Author

but how i works???

what this expression mean??

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

thanks for the help...