topic Re: Re: Show/Hide chart based on Button & Listbox selections. in QlikView

Show/Hide chart based on Button & Listbox selections.

Mon, 09 Jun 2014 05:17:35 GMT

Hi QV,

I have a requirement where chart A should be displayed if I select a Button and a value in the Listbox.

I tried with getselectedcount(field)>0.

It's working on listbox selection, but when I navigate from one button to another it's not working.

Here I need to show the chart according to button and listbox selection.

anyone know how to achieve this.

Thanks & Regards,

Ananth

Re: Show/Hide chart based on Button & Listbox selections.

tresB — Mon, 09 Jun 2014 05:20:35 GMT

On button click set a variable (say vShow) to value (say '1'). Now conditional display expression should like:

=getselectedcount(field)>0 and $(vShow)=1

Re: Show/Hide chart based on Button & Listbox selections.

Mon, 09 Jun 2014 05:30:42 GMT

Totally I have 4 buttons in my sheet and i'm conditionally displaying the chart for these 4 buttons.

In the chart already I have Conditional expr as

First Button : v_Show='A'

Second Button : v_Show='B'

...

Now I want to display the chart based on Listbox selection along with button.

I tried with getselectedcount(field)>0 and $(vShow)='A'.

but the chart is displaying for all the 4 buttons.

Thanks,

Ananth

Re: Show/Hide chart based on Button & Listbox selections.

tresB — Mon, 09 Jun 2014 05:32:31 GMT

Could you post your sample app?

Re: Re: Show/Hide chart based on Button & Listbox selections.

jagan — Mon, 09 Jun 2014 05:42:40 GMT

Hi Ananth,

Please find attached file for solution, used variable in button, on button click the variable value changes using the Action in the button. The charts are show/display by using the Chart Properties -> Layout -> Show Conditional option.

Regards,

Jagan.

Re: Re: Show/Hide chart based on Button & Listbox selections.

Mon, 09 Jun 2014 05:51:34 GMT

Hi tresesco,

Here I'm attaching a sample.

In this charts are overlapping. Under Enrollment button and a selection in China Area list box selection Im displaying china area performance Enrollment.

When I switch to Activations or some other buttoon, if I select a value in the China Area Listbox still im getting the Enrollment Performance.

Here If i Select Activations then i would get Activations performance only.

Thanks...

Re: Re: Show/Hide chart based on Button & Listbox selections.

Mon, 09 Jun 2014 05:52:58 GMT

Hi jagan, Here I'm using personal edition. Please can you post the screenshots of it.

Thanks

Re: Show/Hide chart based on Button & Listbox selections.

ramasaisaksoft — Mon, 09 Jun 2014 06:02:28 GMT

Hi Ananth ,

I know the solution for this .

please call me on 8376964364 i will explain in phone.

Re: Show/Hide chart based on Button & Listbox selections.

ramasaisaksoft — Mon, 09 Jun 2014 07:01:51 GMT

Hi,

please check the below attached sheet for u r problem.

Re: Show/Hide chart based on Button & Listbox selections.

Mon, 09 Jun 2014 07:05:17 GMT

Hi Sai,

Thanks for your response, my need is some what different than what you explained.

Re: Show/Hide chart based on Button & Listbox selections.

CELAMBARASAN — Mon, 09 Jun 2014 07:17:27 GMT

Try with this condition

GetSelectedCount(Area)>0 and v_showchart = 'A'