How to set message instead of no data to display

[#1]

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.

[salto]

If you only need "No Failures":

Sum({<Result={'Fail'}>} distinct Reference)/Sum(Distinct(Reference)) as the Calculation Condition in the General tab.

And in Error Messages set Default(Override all error messages) as No Failures

Hope this helps.

[saumyashah90]

if it is a dimension: you can remove it by selecting suppress null values

if it is a expression : for example Employee  Number

then you just write if(count([Employee Number]<=0,'Your Message',Count([Employee Number]))

[#4]

Thanks and I have used the same but still it's showing same No Data to Display

Please help is there anyother I need to change

[salto]

Please upload a sample qvw so we can check.

[#6]

Please find attched and help me how to set it

[salto · Accepted solution]

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.

[#8]

Thanks very much SALTO and it's working.

[Mchristian76]

So simple yet, brilliant.  Thank you!