Is it possible to make custom message when there is no data?

[#1]

Hi,

I have datasource as Excel file. The file contains two sheets. Sheet A contains data. Sheet B containd only columnnames but there is no values. i,e Sheet B is an empty sheet with out data. But the sheet will get values in coming weeks. So for now I created qvw. The qvw contains two sheets with two straight table. I would need to show to my user a custom message whenever there is no data it should show 'There is no data' with column names. If there is data it should populate with values.

Is it possible?

Thanks in advance.

[#2]

Please find attached qvw. I would need to show in SheetB straight table as 'There is no data' . I know if there is no data it will show 'No data to Display' in bar chart. I need now in Staright table. can anyone help me please.

[#3]

try the Replace function

[#4]

Thanks. How can I use replace.any example please?

[#5]

Hi Amelia,

look at my exam app. I used and defined  the calc condition in general tab of chart "B"

RR

[#6]

Thanks. Perfect. Is it possible to see the same message with column names?

[#7]

use this as an expression and the straight table should display columnname(the dimension you have chosen) and the message 'There is no data'

=Replace(Count(Distinct(Reference_SheetB)), '0', 'There is no data')

[sunilkumarqv]

See attached

and you may need to do some changes like as attached

[#9]

No, not that way.

Workarounds maybe

- put the fieldnames into your message

- create a textbox with according message and use its showing condition on layout tab. Put the textbox over the chart B

RR

[alex_millan]

Hi Amelia,

you always can set a calcul condition on your object and whenever this condition doesn't apply make the application show your custom message.

You can set your custom error messages in the general tab, below the chart types in the "error messages" button.

Hope this will help you!

Cheers!