Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Folks,
I need to show charts when values selected in listbox only rest of time it should hide. I have used Getselectedcount but its not working. I have seen a demo app. but its working in it. Please find the sample app and suggest me further.
Regards
Krishna
Hi,
Uncheck the Show All Sheets and Objects.
Settings -> Document Properties -> Security..
or
Ctrl + Shift + S
Attached file is empty.
Hi,
Sorry Something went wrong.Please find now.
Hi Krishna,
Kindly attach file So that we can share our best knowledge.
Ramya.
Hi Ramya,
I already attached sample file.Please find it.
Hi Krishna,
Try like this
Chart Properties -> Layout -> Show -> Conditional -> and give
=GetSelectedCount(FieldName) > 0
Hope this helps you.
Regards,
Jagan.
hi
u can use show /hide property
in properties layout u can give condition 0 or 1
hope this helps
Thank you
Suresh
Hi,
Uncheck the Show All Sheets and Objects.
Settings -> Document Properties -> Security..
or
Ctrl + Shift + S
Go to chart properties->Layout tab-> check conditional option and put below code
if(getselectedcount(Employee)>0,1,0)
Hi Krishna,
Try this code :
Solution : Chart Properties -> Layout -> Show Header -> click Conditional -> write = getselectedcount(Field) > 0
Ramya.