topic Re: Activate multiple object in qlikview action in QlikView

Activate multiple object in qlikview action

ashishpalkar — Thu, 09 Jul 2015 18:28:56 GMT

Hi There

how to activate multiple object in qlikview action?

Thanks,

Re: Activate multiple object in qlikview action

MK_QSL — Thu, 09 Jul 2015 18:35:00 GMT

Can you please describe little more on your requirements?

Re: Activate multiple object in qlikview action

ashishpalkar — Thu, 09 Jul 2015 18:42:24 GMT

I have 10 Objects in Sheet 1 , another 10 objects in sheet 2.

I want to remove sheets and add all objects in one single sheet.

Now I have created 2 buttons , after clinking button A 10 Objects should be display , after clicking on Button B 10 Objects should be display.

Re: Activate multiple object in qlikview action

petter — Thu, 09 Jul 2015 18:46:34 GMT

Where are you buttons? On the Sheet 1 or Sheet2 ... You will have to move each of the objects to a new Sheet... Is it ok for you to have a Macro or do you need to do it in regular non-macro Actions?

Re: Activate multiple object in qlikview action

MK_QSL — Thu, 09 Jul 2015 18:49:32 GMT

Create a Variable vList

Value set as 0

Now Create a Button/Text Object

Name as List

Action - Add - External - Set Variable

Variable

vList

Value

=If(vList = 0, 1, 0)

Now for all 10 Objects/Charts go to layout tab

Show

Conditional

vList = 1

Now for all other 10 Objects/Chart go to layout tab

Show

Conditional

vList = 0

Re: Activate multiple object in qlikview action

daniel_kusiak — Thu, 09 Jul 2015 18:52:24 GMT

Please see the attached file.

Re: Activate multiple object in qlikview action

ashishpalkar — Thu, 09 Jul 2015 18:57:27 GMT

Thanks for the quick response, what if I add 2 more buttons, each should show 10 Objects respectively.

Now we have

Button A - 10 Objects

Button B - 10 Objects

Button C - 10 Objects

Button D - 10 Objects

All objects are on same sheet.

Re: Activate multiple object in qlikview action

MK_QSL — Thu, 09 Jul 2015 19:01:08 GMT

like this?

Re: Activate multiple object in qlikview action

ashishpalkar — Thu, 09 Jul 2015 19:06:22 GMT

Thanks , it looks what I needed. One observation, when click on button twice associated objects is getting disappear.

Re: Activate multiple object in qlikview action

MK_QSL — Thu, 09 Jul 2015 19:10:26 GMT

Change Action as below

=If(vList <> 1,1,1)

=If(vList <> 1,2,2)

etc

Re: Activate multiple object in qlikview action

ashishpalkar — Thu, 09 Jul 2015 20:00:10 GMT

Thanks

Re: Activate multiple object in qlikview action

MK_QSL — Thu, 09 Jul 2015 21:46:49 GMT

Kindly close this thread by selecting appropriate answer..