Option 1:
Create 2 HTML reports
- first report with the table when data is present and set condition to send this report when table has values
- second report with your custom message condition to run this report when there is no data available.
Option 2:
- Use CSS (subject to CSS support in destination client: Web browser, Mail clients etc) and try not to display an object (see code below). In there I am using display: none style which is created in NPrinting when generating report depending on data availability in the table. Below code is just example which hides table and shows text "There is no Table to show", but if I would have display: none set in p1 style instead I could show table and hide custom message. Also note that i put style in between body tags as those were used in email embedded reports
...<html>
<body>
<style>
table {
display: none;
}
p1 {
}
</style>
<table cellspacing=0 style="border-collapse:collapse;">
<tr>
<td>Dim1</td><td>CountExp</td><td>SumExp</td>
</tr><tr>
<td>A</td><td>649</td><td>27564</td>
</tr><tr>
<td>B</td><td>679</td><td>82187</td>
</tr><tr>
<td>147668</td>
</tr>
</table>
<p1>
There is no Table to show
</p1>
</body>
...</html>
Option 3:
Create our HTML code in Qlik Table just like in the pivot table example mentioned in my blog post:
https://nprintingadventures.com/2020/04/24/how-to-build-html-pivot-table-in-nprinting/
this is more complicated option but it would be the one I would use preferably.
cheers
Lech
cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
