topic Re: Overwriting Pie Chart's default error message in QlikView

Overwriting Pie Chart's default error message

Tue, 10 Sep 2013 13:24:51 GMT

My pie chart displays segment based on a expression. I can see it displays segments correcly and at times it is not displaying any segment instead it displays error message "No data to display". It is correct that there is no data to display, but I need to overwrite this error message with custom message that is more relavent why it is missing the data.

Is there is way to overwrite Pie Chart's default error messages and it should be

Re: Overwriting Pie Chart's default error message

stigchel — Tue, 10 Sep 2013 13:29:43 GMT

In the properties\general tab of the chart there is an error messages button where you can create custom error message. Also on this tab, Create a calculation condition first to control when this happens.

(Edit Typo)

Re: Overwriting Pie Chart's default error message

Anonymous — Tue, 10 Sep 2013 14:15:01 GMT

hi,

hope the attached file will be helpful for you.

Regards

Ashok

Re: Overwriting Pie Chart's default error message

Tue, 10 Sep 2013 14:44:40 GMT

HI,

PFA Hope it helps you

Re: Overwriting Pie Chart's default error message

Tue, 10 Sep 2013 15:08:40 GMT

Thanks All,

All the response was very helpful to derive my solution. I have a question on writing a condition.

I used below condition to evaluate the data then I wrote the custom error message in the "Error Message" section.

What is the difference between " If ([condition],1,0)" and "if ([condition],0,1)".

The first one worked for me and not the latter, why?

Re: Overwriting Pie Chart's default error message

stigchel — Tue, 10 Sep 2013 15:34:59 GMT

The calculation condition needs to evaluate to true to trigger the custom error message 'Calculation condition unfulfilled'.

So you also do not need the if and can use [Condition] alone

Re: Overwriting Pie Chart's default error message

Tue, 10 Sep 2013 15:40:57 GMT

Nope. that didn't work.

I have to give if ([condition]), then it is working.

Actually, I would like to know what makes the difference if we interchanging the (1, 0) in the condition?

Re: Overwriting Pie Chart's default error message

stigchel — Tue, 10 Sep 2013 16:00:14 GMT

The [Condition] itself needs to evaluate to either true or false. An example: (Calculation condition)

GetSelectedCount(Field)=1 --> this evaluates to true if one item in Field is selected and will then display the chart

if(GetSelectedCount(Field)=1,0,1) --> this will work the other way around and will display the chart when the nr of selections in Field does not equal 1

0=False

1=True (Actually qv uses -1, but it will work)