Error mesage in chart

[manoranjan_d]

Hi all,

I m using two separate 2 bar charts,

In chart1 there is two stack bar data of 2015, 2016.

In chart2 there is only 2016 stack bar chart.

Now the scenario is, if user select any filters "example dept" and chart1 will show only 2015 data in chart1 bcoz there is no data in 2016,

so my chart2 has to show some error msg for this issue in chart2. how can i achieve the error  msg in chart2 when there is no data.

[Anonymous]

Hi Manoranjan.

Use a calculation condition and on Error Messages, write do you want on Calculation Conditio Unfullfilled.

Regards!!

[swuehl]

You can set a calculation condition that returns false if there is no data on general tab of your chart, maybe

=Sum({<Year = {2016}>} Amount) >0

or whatever you are using in your expression,

then adapt the error message text in error messages dialog for the calculation condition.

[migueldelval]

Hi Manoranjan,

You use Conditional show. If(year=2015, 0, 1), and put at the same place other object.

Regards

Miguel del Valle

[manoranjan_d]

I can found lot of option in error message, so from that which one i can select

[Anonymous]

Look at my response Manoranjan.

Regards!

[Anonymous]

Hi,

Select " Calculation condition unfulfilled"

Hope it helps!!

[Anil_Babu_Samineni]

If User Select any then????

[narendiran]

Hi

Use the relevant standard message or use custom message with either text or with expression.

[swuehl]

Again, two steps to take

1) Define a 'calculation condition' on general tab (see my previous post for an example)

2) Adapt the error message if needed, change the message for 'calculation condition unfulfilled' in the error messages dialog (button on general tab to open the dialog)