topic Re: How to display conditional comment in QlikView

How to display conditional comment

wossenhh — Tue, 28 Oct 2014 13:26:48 GMT

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

Re: How to display conditional comment

its_anandrjs — Tue, 28 Oct 2014 13:36:01 GMT

Hi,

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

Regards

Anand

Re: How to display conditional comment

Tue, 28 Oct 2014 13:38:37 GMT

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

Re: How to display conditional comment

Tue, 28 Oct 2014 13:40:35 GMT

Hi,

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

Re: How to display conditional comment

its_anandrjs — Tue, 28 Oct 2014 13:56:25 GMT

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

With Data

For text object write like

Regards

Anand

Re: How to display conditional comment

jpenuliar — Tue, 28 Oct 2014 13:57:45 GMT

Agree on this one

Re: How to display conditional comment

wossenhh — Tue, 28 Oct 2014 16:21:25 GMT

Hi Anand,

Can you please post the QVW file?