Macro Assistance

[raynac]

I am hoping someone can direct me to the right code for something.

If a macro looks like this:

Sub SecondQtr

     ActiveDocument.ClearAll(false)

     ActiveDocument.Fields("Quarter").Select("Q2")

end sub

I am looking for "Sub NOTSecondQTR", more or less.  Is there anyway to select everything that's NOT Q2?  Obviously, when there are only 4 options you can dictate which three to choose, but in the code I am writing, there are about 20 options, of which I am trying to exclude a single one.  I looked in the reference manual but didn't see anything.

Any help would be appreciated!  Thank you!

[danielrozental]

You should probably use actions for this. You could try selecting a value and then do "toggle select" or select excluded.

[raynac]

Hi Daniel...thank you for your response!

I have been working with Qlikview for years but am somewhat new to Macroes.  The "toggle select" is something that can be written into the macro?  I know the "select excluded" is a right click action, and there is no way that my company owner is going to be ok with having to do something manual.

[danielrozental]

I'm not talking about doing anything manually, Actions are a feature implemented in QV9 to replace most common macro uses.

You can also do it in a macro

ActiveDocument.Fields("Month").Select ">4"

ActiveDocument.Fields("Month").ToggleSelect "<8"

[raynac]

Oh, thank you Daniel!!  I will take a look at this and see if I can accomplish what I am trying to do 😄

Best,

Rayna