topic Simple Macro Code in QlikView

Simple Macro Code

shumailh — Sun, 15 Nov 2009 22:44:59 GMT

Can anyone please help on the below function, I am trying to select the value U and V on the sheet activation but it's not working with the below code... [:s]

sub MakeSelection()
ActiveDocument.Fields("BLOCKCODE1").Select 'U','V'
ActiveDocument.Fields("BLOCKCODE2").Select 'U','V'
ActiveDocument.Fields("BLOCKCODE3").Select 'U','V'
end sub

Regards,
Shumail Hussain

Simple Macro Code

sparur — Sun, 15 Nov 2009 23:28:59 GMT

Hi,

try that example:

sub MakeSelection()

set curentField = ActiveDocument.Fields("BLOCKCODE1")

'Initialize array of values for selection

set arrayOfValues = curentField.GetNoValues

'Add New Element in array
arrayOfValues.add

'Fill this element
arrayOfValues(0).Text = "U"
arrayOfValues(0).IsNumeric = false

'Add New Element in array
arrayOfValues.add

'Fill this element
arrayOfValues(1).Text = "V"
arrayOfValues(1).IsNumeric = false

curentField.SelectValues arrayOfValues

end sub

for more details see in attachment and APIguide.qvw.
best regards, Anatoly.

Simple Macro Code

Anonymous — Mon, 16 Nov 2009 08:26:15 GMT

Hi Shumail,

Here's an example for selecting U and V in a field called F1:

sub Sel()
ActiveDocument.Fields("F1").Select "U"
ActiveDocument.Fields("F1").ToggleSelect "V"
end sub

This can be created using actions instead of running it as a macro although it shouldn't really make any difference.

Simple Macro Code

shumailh — Mon, 16 Nov 2009 13:09:00 GMT

your code is working perfectly...

Thanks Johannes!

Regards,
Shumail Hussain

Simple Macro Code

shumailh — Mon, 16 Nov 2009 13:10:17 GMT

Thanks Anatoly, your code is also working.

Regards,
Shumail Hussain

Simple Macro Code

Fri, 27 Aug 2010 14:25:39 GMT

Thanks for sharing .. worked wonders