Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
wossenhh
Creator
Creator

How to display conditional comment

Hi, I am running a report daily and QV provides me data’s with straight tables. I want to display a comment like ‘No data’s for today’ when there is no data from the database instead of displaying blank tables. Any help with that? Thanks, Wossen

6 Replies
its_anandrjs

Hi,

Go for Custom Error Message from chart properties >> Click on the error messages button and you get many messages.

Custom Msg.png

Regards

Anand

Not applicable

Hi Wossen,

when there is no data from Source, the table in the script will not be loaded.

So check for table and set a flag.

In QVW use a text box to show, if (Flag='Y','No data from Data source').

If you want to show in every table then show using Custom Error message Property

Not applicable

Hi,

In general tab condition you have error messages there you can write some condition

its_anandrjs

Another approach is use a variable

LET vRow = NoOfRows('TableName');

And take a text object in layout option write If( $(vRow) <= 0 ,1,0 ) and put this text box in the top to the chart so when there is 0 row loaded in the model this text object display 'No data from Data source'.

I assume a example here

When there is no data then it display

NOData.png

With Data

Tab.png

For text object write like

LAyout.png

Regards

Anand

jpenuliar
Partner
Partner

Agree on this one

wossenhh
Creator
Creator
Author

Hi Anand,

Can you please post the QVW file?