topic How can I make this select using VBScript? in QlikView

How can I make this select using VBScript?

rcandeo — Fri, 24 Feb 2012 16:25:09 GMT

I use a macro to get an inicial selection and it works fine.

My problem is that for an specific field I wannna make a selection for 3 diferent results and I am not getting the correct expression.

Here is my statement:

Sub SelecaoInicial

ActiveDocument.GetField("Tipo_Faturamento").Select "Faturado"

ActiveDocument.GetField("Family").Select "AA"

ActiveDocument.GetField("Family").Select "BB"

ActiveDocument.GetField("Family").Select "CC"

End Sub

I wanna select for Family these 3 options: AA, BB and CC, but it´s only selecting the last line - CC.

I´ve tried to put AND and OR, but all my atemptatives not worked.

Thank You

Robson

Fri, 24 Feb 2012 16:43:03 GMT

Start with .Select then for following statements use .ToggleSelect. for example

Sub SelecaoInicial

ActiveDocument.GetField("Tipo_Faturamento").Select "Faturado"

ActiveDocument.GetField("Family").Select "AA"

ActiveDocument.GetField("Family").ToggleSelect "BB"

ActiveDocument.GetField("Family").ToggleSelect "CC"

End Sub

rcandeo — Fri, 24 Feb 2012 17:06:52 GMT

Thank You very much