topic Macro Assistance in QlikView

Macro Assistance

raynac — Mon, 21 Jan 2013 22:00:06 GMT

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!

Re: Macro Assistance

danielrozental — Tue, 22 Jan 2013 00:28:33 GMT

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

Re: Macro Assistance

raynac — Tue, 22 Jan 2013 14:20:19 GMT

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.

Re: Macro Assistance

danielrozental — Tue, 22 Jan 2013 18:02:34 GMT

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"

Re: Macro Assistance

raynac — Tue, 22 Jan 2013 18:06:11 GMT

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