topic button action in QlikView

button action

Thu, 10 Feb 2011 16:04:02 GMT

Hi,

I'ld like to update slider selection in button action. Please let me know how i can do it?

Thanks

button action

matt_crowther — Thu, 10 Feb 2011 16:08:15 GMT

Assuming the Slider is linked to a variable you can add a button with an Action to change the variable (Actions>External>Set Variable).

Hope that helps,

Matt - Visual Analytics Ltd

button action

Thu, 10 Feb 2011 16:09:51 GMT

I need to change multiple values for slider i.e range ex: jan - may

button action

matt_crowther — Thu, 10 Feb 2011 16:17:23 GMT

Could you post an example file?

It should be possible.

All the best,

Matt - Visual Analytics Ltd

button action

Fri, 11 Feb 2011 12:18:32 GMT

In below image, slider selection has to be changed according to the buttons clicks...

button action

matt_crowther — Fri, 11 Feb 2011 12:54:32 GMT

This may need a little further adjustment but I can get the principal working:

Associate your Month dimension with it's numeric - ie Jan = 1, Feb = 2 etc (I've caleld it 'ID'). Set your button to launch the following macro (in the case of Jun-Sep):

Sub JunSep
ActiveDocument.Fields("ID").Select ">=6<=9"
End Sub

That will make the appropriate selections for you - the challenge would be to get that to display in the Slider object - but I guess that's an aesthetic issue rather that a practical one.

Hope that helps,

Matt - Visual Analytics Ltd

button action

Miguel_Angel_Baeyens — Fri, 11 Feb 2011 13:29:38 GMT

Hi,

Check the attached example. Both variables and fields will work with button actions without need of macro.

Hope that helps.

button action

matt_crowther — Fri, 11 Feb 2011 13:42:32 GMT

Alternate soultion to the above that allows for multiple selections in the Month field based on a macro so whilst it's a Macro it should afford you more flexibility than '<' or '>'.

Either of the methods should work so I guess its which suits your needs the most.

All the best,

Matt - Visual Analytics Ltd