topic Re: If Table empty - HTML Report in Qlik NPrinting

If Table empty - HTML Report

Danijel — Tue, 04 Feb 2020 09:38:15 GMT

Hello everybody,

I send a monthly report by mail based on an embedded HTML report.

Now it is possible that in one month there are no values in the table, the mail should be sent anyway.

Is it possible to display a text instead of the table if the table is empty (check e.g. by a variable)?

I could imagine it like this: If values exist, show table, if no values exist, show text "no values".

Does anyone have an idea?

Thanks in advance.

Re: If Table empty - HTML Report

Lech_Miszkiewicz — Wed, 05 Feb 2020 00:22:51 GMT

This is not NPrinitng question really, right?

It is down to HTML and how different email clients will deal with it.

Below you can see example of what i have tested...It worked on web clients, iphone mail and partially worked on Outlook 2016 client. (Outlook 2016-I was able to hide/show <table> tag, but <p1> hide/show did not work.. I am testing now if using other tags would work like h1 etc...

But the idea behind is more less like on the picture attached:

Re: If Table empty - HTML Report

Lech_Miszkiewicz — Wed, 05 Feb 2020 00:38:27 GMT

Just wanted to confirm that that usual <h1> tag worked when used with style display: none;

Re: If Table empty - HTML Report

Danijel — Wed, 05 Feb 2020 07:52:51 GMT

Hi @Lech_Miszkiewicz

Yeah, you're right, it's actually an html question.

Thanks for your test and your hints, I will test that.

Re: If Table empty - HTML Report

sique132 — Wed, 23 Feb 2022 14:18:50 GMT

Hi @Lech_Miszkiewicz , thanks for this as it is working for me using the h1 but any suggestions on how to maintain formatting in the embed?

Re: If Table empty - HTML Report

Lech_Miszkiewicz — Thu, 24 Feb 2022 04:23:28 GMT

Hi @sique132

not sure what you mean. If you mean how to style html then i suggest you study the basics in help document here:

https://help.qlik.com/en-US/nprinting/May2021/Content/NPrinting/HTMLReports/HTML-formatting.htm

If you have more requirements you may search community for topics similar to those below:

https://community.qlik.com/t5/Qlik-NPrinting-Discussions/HTML-table-styling-does-not-work-with-with-quot-Keep-Source/m-p/1882935#M34805

cheers

Re: If Table empty - HTML Report

sique132 — Thu, 24 Feb 2022 13:26:17 GMT

No, i have the styling but it's not coming though in the embedded email, just in the attachment. The screenshots I included show the attachment vs the email.

Re: If Table empty - HTML Report

Lech_Miszkiewicz — Thu, 24 Feb 2022 21:33:33 GMT

Hi, so you have to study what kind of styling is the mail client accepting - this is not a question of nprinting but rather CSS compatibility and support in web browsers and email clients. You can use websites like this one: https://www.campaignmonitor.com/css/ to check what is supported and what isn't (just like example on below picture)

cheers