Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
piyush_s11
Creator
Creator

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
settu_periasamy
Master III
Master III

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

 

View solution in original post

9 Replies
shiveshsingh
Master
Master

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
Creator
Creator
Author

Hi Shivesh,

it's not working...

shiveshsingh
Master
Master

Hi

 

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

piyush_s11
Creator
Creator
Author

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
Master
Master

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

settu_periasamy
Master III
Master III

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
Creator
Creator
Author

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

settu_periasamy
Master III
Master III

sure. will have a look

piyush_s11
Creator
Creator
Author

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.