Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
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...