Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm trying to hide a chart when I select x values, so I wrote a condition but doesn't work.
I get tired of change my code one and other time and I coded in the conditional "0 = 1" but didn't work too. What can it be?
Best regards,
Leandro
Do you have a example of the application?
Try the basic to be sure: put a 0 or 1 in the condition field, to try hide/unhide the chart.
in layout tab of your chart, conditional (x=2)
GetSelectedCount(yourfield)<>2
Hi,
you can use this expression in the chart show condition
GetSelectedCount(Name_of_field)=0
KR.
You are talking about hiding the chart itself, right? On the Layout tab of the properties window is where you find the Conditional option for that. If you use 0=1 as expression the chart will hide itself. Don't use double quotes around the expression.
You'll want to use something like =if(getselectedcount(MyField)>10,0,1) which would hide the chart if you select more than 10 values in the field MyField.
Hi Elena
You can use this simple expressions:
Conditional : GetSelectedCount(Company)>4,
so if i select more than 4 company. so my textbox will appear and if i selected lower than 4 Company, my textbox still hidding.
I hope, you´ll find it useful
Beck
Create one chart(like bar chart) and also create two buttons,also one variable
1st button-text(set to 0),add action (select in field-give variable and value(=0))
2nd button-text(set to 1),add action(select in field-give the same variable and value(=1))
in the chart goto layout condition (variable=0 or =1)
based on 1 the chart will display, based on 0 the chart will hide
If you are doing everything right(you believe) and still it is not hiding, there could be another possibility. Check the security settings(Settings->Document Properties->Security); uncheck 'Show All Sheets and Objects'.
Try this at the Layout tab, Conditional field: if(count(distinct(Field))>0,0,1)
Hope it helps!
Best,
T
To add to this, sometimes weird behaviour is scene when your chart is a copy of another chart. If that is the case, then try creating a new chart from scratch.
Thanks,
Singh