You can create two charts and enable disable them using Conditional Show under Layout tab. You can put your codition in the conditional show so if it's true it shows one chart and second chart for false.
Other option is to add/remove dimension or expression using macros.
Edit: just recalled that in v9 it provides a conditional show/hid option under presentation. See if you can utilize that. Sorry, don't have v9 with me right now.
In version 9 in a straight table, you can go to Properties -> Presentation -> Columns -> Conditional. Set the condition to when you want the column to display. It sounds like you've gotten that far, and don't know what to put in the condition. But you haven't told me when you want the column to display, so I can't tell you what expression to enter there.
OK, try getselectedcount(YourField). If there are no selections, the value will be 0 (false), so the column shouldn't display. If there are selections, the value will be > 0, which will evaluate to true, so it should display.
Hey John i have a question for you, do you remember the subject of the negative and positive values in a pay chart?, it is possible that when negative and positive appear the chart automatically change to a bar chart???
Sure. Create a pie chart with this display condition:
min(aggr(sum(YourValue),YourDimension))>=0
And a bar chart with the opposite display condition:
min(aggr(sum(YourValue),YourDimension))<0
You have two charts to maintain instead of one, but if the only difference is the chart type, the most you ever have to do is delete one, copy from the other, and change the condition. So it's not actually a maintenance problem in practice.
Hi John again, sorry to bother you so much but i have so many question in this new software, i have a single table chart, then i select one of the values in the table and a table appears,how can i put a button that close that table without clearing the actual selections?? Because the table dissapear clicking on clear button but i need to put a button that will close that table, can you help me with that plz?
Well, you can set up a button to set a variable using a macro or action, and then set up the field so that when selections are made or changed, it sets the variable differently, then use the variable in the show condition for the chart. But that seems like a whole lot of work. Why do you need to add a button to close the chart? Do you want something else to go where that chart goes? How about either using the minimize button on the chart, or using autominimize across related charts?
