topic Re: select all in button action in QlikView

select all in button action

anuradhaa — Tue, 01 Jul 2014 12:06:51 GMT

i want to select all in a field by clicking a button.

But don't know how to do that. please help me

Thanks

Re: select all in button action

kji — Tue, 01 Jul 2014 12:13:21 GMT

Use the select "Select in Field" action, with the search string *.

Re: select all in button action

Tue, 01 Jul 2014 12:15:17 GMT

you have to create a button -> properties-> trigger -> selection in field -> select all

i attached a file for you where you can see what you have to do but watch out it is german 😉

regards,

Re: select all in button action

anuradhaa — Tue, 01 Jul 2014 12:22:29 GMT

here i have sales vales in feild, and in action button i need to select all sales. please help me

Re: select all in button action

Tue, 01 Jul 2014 12:24:48 GMT

Create a Button and set an Action as

Action-->Add-->Selection-->Select possible

and then Give Field as [Sales Values]

Re: select all in button action

anuradhaa — Tue, 01 Jul 2014 12:27:31 GMT

there is no option called select all, could you please send me the exact english translation

Re: select all in button action

Tue, 01 Jul 2014 12:31:02 GMT

There is no such option called select all, the same can be done by "Select Possible" action as I posted above

Re: select all in button action

anuradhaa — Tue, 01 Jul 2014 12:38:05 GMT

no there is a difference between those two options.

i have add select all option in selection box volume.

also add select possible in button.

i have created slider and variable.

so in my volume selection box i have set expression,

if(bbbbb <= VOLUME,VOLUME)

and bbbbb is a variable set in slider.

so once i select variable valuse selection box shows only volumes > selection variable val.

but the sheet doesn't change. one i click select all in selection box entire sheet change. but when i use select possible only volume selection box get selectted.

what i need is give button to users as "select all" once the select a value in slider, because they nee to see entire sheet based on there selection,

ex, when volume > 200

Thank You

Re: select all in button action

Tue, 01 Jul 2014 13:48:03 GMT

Hi,

You need to write the macro.

Follow the below steps:

1) Create a button object -->Properties --> Action --> add --> Run Macro. In Macro text box call macro name(Select_All). Paste the below macro in the macro edit module (Ctrl+M).

Sub Select_All

ActiveDocument.Fields("INV_STATUS").SelectAll

End Sub.

In the above macro INV_STATUS is my field name, Replace with field related to your project.

Find the attachment for sample example.

Thank you

Re: select all in button action

Tue, 01 Jul 2014 14:31:55 GMT

Hi Shrikant Koppad Sorry but Why to make it complex when it can be done without macro.

Johan Idh has already answered it correctly. Anuradha Abeysuriya I request you to close the thread if you have got the solution.

Re: select all in button action

anuradhaa — Tue, 01 Jul 2014 15:25:52 GMT

Thanks All