Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
piyush_s11
Contributor

Hide the chart if continet is not selected

Hi,

I wanted to hind the chart if continent is not selected in the filter.

please find attached file for reference.

Thanks

1 Solution

Accepted Solutions

Re: Hide the chart if continet is not selected

Hi,

Try this..

Goto Document Properties -> Security -> Uncheck 'Show All Sheets and Objects'

And In the Chart Layout give this.  =GetSelectedCount(Continent)

Attached your sample

 

9 Replies
shiveshsingh
Honored Contributor

Re: Hide the chart if continet is not selected

You need to go to the layout tab of the chart, then under show you need to put conditional expression - 

like getselectedcount(Field) <>'0'

piyush_s11
Contributor

Re: Hide the chart if continet is not selected

Hi Shivesh,

it's not working...

shiveshsingh
Honored Contributor

Re: Hide the chart if continet is not selected

Hi

 

PFA application, when you'll select any value in F listbox, then only the chart will be displayed.

piyush_s11
Contributor

Re: Hide the chart if continet is not selected

Hi Shivesh,

Thanks for your reply.

could you please try the same logic in the file I have attached as I am not getting the expected result in that file

thanks

shiveshsingh
Honored Contributor

Re: Hide the chart if continet is not selected

Sorry man, i don't have license as of now, and would not be able to open your attached file 😞

Re: Hide the chart if continet is not selected

Hi,

Try this..

Goto Document Properties -> Security -> Uncheck 'Show All Sheets and Objects'

And In the Chart Layout give this.  =GetSelectedCount(Continent)

Attached your sample

 

piyush_s11
Contributor

Re: Hide the chart if continet is not selected

Hi Settu,

thanks, I have to the answer.

I have one more question which is posted in this group yesterday with the subject line 

"Show data from the January Month till the month selected for the respective year"

could you please help in this as well. you can consider the attached file for your reference for the same.

thank you once again

Re: Hide the chart if continet is not selected

sure. will have a look

piyush_s11
Contributor

Re: Hide the chart if continet is not selected

Hi Settu,

Required help from you.

I have posted a query with subject "Show percentage of count in Pie Chart".

Could you please look into it & help me out.

thanks in advance.