Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to set message instead of no data to display


Hi,

I have a striaght table and when I am clicking on any selection based on selection the data is changing and when there is no relevant data it is showing 'No Data to Display'. My user wants to see 'No Employees' instead of 'No Data to Display'.

Could anyone help me how to set this as I am not aware of this earlier.

Thanks in advance.

1 Solution

Accepted Solutions
salto
Specialist II
Specialist II

PFA my solution.

I have changed the expressions, becuase you were trying to SUM references that could contain characters.

I have chaned the SUM by COUNT.

Let me know if this helps.

View solution in original post

27 Replies
Anonymous
Not applicable
Author

Amelia D

On the General tab of you Straight Table click on the Error Message button and you can adjust the default QV error messages.

Also on the same tab you can add a Calculation Condition to fine tune things to get want you need.

Best Regards,     Bill

salto
Specialist II
Specialist II

Hi,

In the General tab of the Chart properties, there is "error Messages" button. You could try setting a custom error message instead of the one you are receiving.

Hth.

Not applicable
Author

Thanks and I set Default(Override for all error messages) as No Employees but it's not changing stiil it's showing 'No Data to Display' do I need to change anything?

Please help me.

Anonymous
Not applicable
Author

Amelia

In the Calculation Condition add an expression like:

     count(Employees) = 0

Then put your message text in Error Message instead of Calculation Condition Unfulfilled

Best Regards,     Bill

Not applicable
Author

Thanks and I did the same thing and it's showing completely No Employees even if there is data

Please help me am I missing anything?

Anonymous
Not applicable
Author

Amelia

Can you reply & paste your Calculation Condition expression into it for us to look at.



Best Regards,     Bill

Not applicable
Author

The expession is

Count(Employees)=0 under Calculated Condition in general tab

Anonymous
Not applicable
Author

Amelia

Ooops !! Sorry my bad :

I should have said


     count(Employees) > 0

Not applicable
Author

Amelia

Put the message on "unfullfilled calculation condition"

best regards

chris