Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
subin6600
Creator III
Creator III

Need help for writing macros for selecting Number field values

Hi,

I need to write a macro which can select few number values in a field while opening a tab.

Can anyone plz help me with it?

1 Solution

Accepted Solutions
Not applicable

Hi Subin,

This is for selecting entire field data:

Sub SelectALlFieldData

    ActiveDocument.GetSheetObject("LB48").SelectAll

End Sub

This is for selecting some values of the object(listbox):

No need of macro for this


Trigger actions->select infield

FieldName='(value1|value2|value3value4)'

Hope it helps you

Regards..

View solution in original post

3 Replies
Not applicable

Hi Subin,

This is for selecting entire field data:

Sub SelectALlFieldData

    ActiveDocument.GetSheetObject("LB48").SelectAll

End Sub

This is for selecting some values of the object(listbox):

No need of macro for this


Trigger actions->select infield

FieldName='(value1|value2|value3value4)'

Hope it helps you

Regards..

Not applicable

Hi rav,

is it possible to do it with a macro?

subin6600
Creator III
Creator III
Author

Now we have direct option for it like select in field where you can give the options in the field you want it to be selected in the format FieldName='(value1|value2|value3|value4)'

Try avoiding macros as far as possible.