topic Selecting multiple values in a certain field in QlikView

Selecting multiple values in a certain field

Mon, 07 Dec 2009 21:57:24 GMT

Hello,

I have a question regarding using macros in Qlik.

I know how to select a value from a certain field using a macro with VBScript language, but i want to select multiple values.

Also i would like to know if i can reduce data using macros( the equivalent of reduce data from file menu ).

Please help.[*-)]

AW:Selecting multiple values in a certain field

Mon, 07 Dec 2009 22:05:12 GMT

Hi,

you can do it withToggleSelect:

<pre>sub multi_select
ActiveDocument.Fields("Field1").Select "a"
ActiveDocument.Fields("Field1").ToggleSelect "b"
end sub

Kind regards.

Selecting multiple values in a certain field

Oleg_Troyansky — Mon, 07 Dec 2009 22:08:12 GMT

Check out those APIs:

"SelectValues",

"SelectAndValues",

"ReduceData"

If you are not already using QlikView API Guide, I highly recommend it - it's under Program Files\QlikView\Documentation\ folder.

regards!

AW:Selecting multiple values in a certain field

Tue, 08 Dec 2009 15:09:56 GMT

Thank you very much!

Have a nice day!

Selecting multiple values in a certain field

Tue, 08 Dec 2009 15:11:37 GMT

Thank you very much!

I will look up for those!

Re: Selecting multiple values in a certain field

Tue, 16 Dec 2014 09:27:53 GMT

How do I exclude only 1 value from a certain field ?

Re: Selecting multiple values in a certain field

Mon, 29 Dec 2014 10:42:05 GMT

Hi,

I am trying to make a a selection from a list box which has an expression in it.

I generally use the below syntax to select values from list box:-

listbox3=Array("<value>")

Set Qv = CreateObject("QlikTech.QlikView")

Set QvDoc = Qv.OpenDoc("<QV_File_location>")

QvDoc.GetSheetObject("<objectID")

Set fz = QvDoc.Fields("objectname")

for each v in listbox3

fz.ToggleSelect v

But whenever I try to access an expression from a list box, it will have an objectID but wont have an object name ? How can I solve for this problem ?