topic Re: Macro to select all values in QlikView

Macro to select all values

Wed, 07 Oct 2015 10:00:47 GMT

i have two questions for macro for default selections.

1.How to apply a macro to select all values in a particular list box.

2. How to apply a macro to select all values except one in a particular list box.

Can anyone help me out with code here.

Khushboo

Re: Macro to select all values

hic — Wed, 07 Oct 2015 10:14:32 GMT

No, you should not use a macro for this. Macros often don't work in a server environment. See Macros are Bad.

What you can do instead, is to use an Action. If you want to select all but one value in a field you can do this by first selecting the value to exclude, then "Select Excluded".

HIC

Re: Macro to select all values

Wed, 07 Oct 2015 10:46:43 GMT

Thanks Henric.

But client wants us to use macro only so cant help it.

Re: Macro to select all values

petter — Wed, 07 Oct 2015 11:09:28 GMT

If you have to use Macros then this gives you some simple examples:

Sub SelectAll

ActiveDocument.Fields("Month").Select "*"

End Sub

Sub SelectAllButOne

ActiveDocument.Fields("Month").Select "September"

ActiveDocument.Fields("Month").SelectExcluded

End Sub

Re: Macro to select all values

hic — Wed, 07 Oct 2015 11:11:15 GMT

Then you should tell the client that it's a bad solution. Actions are better.

However, the following macro will select all values:

Sub SelectX

ActiveDocument.Fields("Month").Select "*"

End Sub

The following macro will select all except September

Sub SelectY

ActiveDocument.Fields("Month").Select "September"

ActiveDocument.Fields("Month").SelectExcluded

End Sub

HIC

Re: Macro to select all values

Wed, 07 Oct 2015 12:23:58 GMT

Thank You everyone