topic Re: Error mesage in chart in QlikView

Error mesage in chart

manoranjan_d — Tue, 14 Jun 2016 10:45:09 GMT

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.

Re: Error mesage in chart

Anonymous — Tue, 14 Jun 2016 10:50:26 GMT

Hi Manoranjan.

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

Regards!!

Re: Error mesage in chart

swuehl — Tue, 14 Jun 2016 10:51:12 GMT

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.

Re: Error mesage in chart

migueldelval — Tue, 14 Jun 2016 10:52:31 GMT

Hi Manoranjan,

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

Regards

Miguel del Valle

Re: Error mesage in chart

manoranjan_d — Tue, 14 Jun 2016 10:55:49 GMT

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

Re: Error mesage in chart

Anonymous — Tue, 14 Jun 2016 10:59:03 GMT

Look at my response Manoranjan.

Regards!

Re: Error mesage in chart

Anonymous — Tue, 14 Jun 2016 11:01:24 GMT

Hi,

Select " Calculation condition unfulfilled"

Hope it helps!!

Re: Error mesage in chart

Anil_Babu_Samineni — Tue, 14 Jun 2016 11:04:24 GMT

If User Select any then????

Re: Error mesage in chart

narendiran — Tue, 14 Jun 2016 11:09:22 GMT

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

Re: Error mesage in chart

swuehl — Tue, 14 Jun 2016 11:10:58 GMT

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)