topic Re: How to open a chart by selecting something in another chart? in QlikView

How to open a chart by selecting something in another chart?

jblomqvist — Thu, 27 Aug 2015 10:42:28 GMT

Hi all,

How can I activate a chart by making selection in another chart?

For example:

Chart A is a bar chart with three dimension values displayed, Good, Average, Poor.

If I select Poor it should trigger another chart to open in the sheet.

Is there a way to do this?

Re: How to open a chart by selecting something in another chart?

Thu, 27 Aug 2015 10:45:50 GMT

Use triggers or actions

Re: How to open a chart by selecting something in another chart?

a_mullick — Thu, 27 Aug 2015 10:46:36 GMT

Hi,

Yes, in the layout tab of the second chart select Conditional:

And set the condition to GetSelectedCount(<Your_field_name>) = 1

Thanks,

Azam

Re: How to open a chart by selecting something in another chart?

a_mullick — Thu, 27 Aug 2015 10:50:34 GMT

And if it is only the case when you select the value 'Poor', then make the condition:

GetSelectedCount(<Your_field_name>) = 1 AND

GetFieldSelections(<Your_field_name>) = 'Poor'

Azam

Re: How to open a chart by selecting something in another chart?

Anonymous — Thu, 27 Aug 2015 10:54:07 GMT

Hi John,

Yes there is a way to do the above. On your dimesions, you can add two small buttons on overlay two objects over the dimensions and make them transparent. Create a variable, call it whatever you want. The initial value will be 0. When you click on the button, the variable value should turn to 1. In your "Invisible graph," in the Layout Tab, you will put the following code in the conditional statement: =if(<VariableName>=1,1,0). Press Ctrl+Shift+S to show and hide.

If you click on the dimension, it should activate the "invisible graph".

Re: How to open a chart by selecting something in another chart?

gautik92 — Thu, 27 Aug 2015 10:54:13 GMT

create a button and add action activate sheet and mention the sheet id

Re: How to open a chart by selecting something in another chart?

josephinetedesc — Mon, 12 Oct 2015 05:07:05 GMT

Is it possible to have a button with a trigger which opens another chart - on another sheet?

Re: How to open a chart by selecting something in another chart?

gautik92 — Mon, 12 Oct 2015 05:09:24 GMT

ya it is possible

Re: How to open a chart by selecting something in another chart?

Anonymous — Mon, 12 Oct 2015 05:22:38 GMT

Hi John ,

I have sent a application. please check i hope this helps u .

Thanks,

Bunny