topic Need help for writing macros for selecting Number field values in QlikView

Need help for writing macros for selecting Number field values

subin6600 — Fri, 04 Nov 2011 10:06:31 GMT

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?

Re: Need help for writing macros for selecting Number field values

Fri, 04 Nov 2011 13:12:08 GMT

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..

Need help for writing macros for selecting Number field values

Wed, 18 Apr 2012 16:02:21 GMT

Hi rav,

is it possible to do it with a macro?

Need help for writing macros for selecting Number field values

subin6600 — Thu, 19 Apr 2012 05:27:08 GMT

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.