topic Re: KPI object is HTML report doesn't shows any data (sometimes) in Qlik NPrinting

KPI object is HTML report doesn't shows any data (sometimes)

drorelkouby — Mon, 01 May 2023 20:01:30 GMT

Hi,

I have a HTML report in NPrinting v21.14.4.0 (May 2021 SR1) that send few charts and few KPIs by email.

It used to work great until few weeks ago but then randomly it started to send the KPIs without the measurements, just an empty box with the labels.

I have 3 KPIs and each time I run the report it "hide" random KPI... after few executions, sometimes it is able to display everything correctly but after few minutes if I try to execute it again the problem return.

I've seen few posts talking about using extension objects or sizing issues but I've rebuilt the objects in my QlikSense app using a standard KPI chart and also changed the sizing and nothing helped.

Here are some screenshots showing different runs on the report with random empty KPI (just different runs, without changing anything in between):

Sometimes it can take 4-5 runs, with different random outputs until I get a full report.

When everything works fine, this is how it looks like:

Anyone noticed something like that before?

Any ideas what can cause it?

Thanks

Dror

Re: KPI object is HTML report doesn't shows any data (sometimes)

Lech_Miszkiewicz — Mon, 01 May 2023 22:25:58 GMT

Hi @drorelkouby

What is the exact Qlik Sense version you are using - are you meeting criteria which are well documented?
1. https://help.qlik.com/en-US/nprinting/May2021/Content/NPrinting/DeployingQVNprinting/System-requirements_engine.htm
2. Qlik Sense compatibility

Compatibility
Qlik Sense Enterprise on Windows version	Qlik NPrinting version
May 2021	May 2021 IR and later
August 2021	May 2021 SR2 and later
November 2021	May 2021 SR2 and later
February 2022	May 2021 SR2 and later

I am assuming you are using images of those KPI objects,right? Instead have you tried use the actual KPI formulas? I understand it would be more development but I always do it as good practice as you get much better results, you get more control over the object, your object will scale better, look better, you have font control and style sheet control.

Lets confirm that you are on supported configuration first and then we will worry about rest.

thanks

Lech

Re: KPI object is HTML report doesn't shows any data (sometimes)

drorelkouby — Mon, 01 May 2023 22:51:58 GMT

Thank you @Lech_Miszkiewicz on your quick (very quick) reply.

Regarding the QlikSense version, we are using qliksenseserver version 14.97.6 (November 2022 Patch 3).

I've noticed this issue few weeks after we did the upgrade so maybe it's related. We also installed few extensions (one for multi Filter object, one for export to excel button, and one for special Themes) but the objects I'm using in my NPrinting are standard QlikSense objects.

Regarding the way I'm using these KPIs is as you assumed, by "insert image" from my QlikSense report.

To be honest I haven't thought I can replicate the same design using the functions in the HTML designer but I do like the challenge 🙂

I found one of your older posts and I'll use it for help
https://community.qlik.com/t5/Qlik-NPrinting/NPrinting-How-to-achieve-same-appearance-for-KPI-objects/td-p/129035

However, I'm still wonder what happened to my KPI images that it just stopped working right.

Thank you!

Dror

Re: KPI object is HTML report doesn't shows any data (sometimes)

Lech_Miszkiewicz — Tue, 02 May 2023 07:03:35 GMT

Hi @drorelkouby

well - as mentioned in my previous post - the version you are using is not compatible! For that version of Qlik Sense you need to upgrade your NPrinting!

You are on November 2022 Qlik Sense version which is not supported by your version of NPrinting as documented in the link I gave you. This is the most common issue people tend to forget when doing NPrinting - making sure the versions are compatible.

good luck

Re: KPI object is HTML report doesn't shows any data (sometimes)

drorelkouby — Tue, 02 May 2023 14:24:53 GMT

Thank you again @Lech_Miszkiewicz

I'll check with my team about the option of updating our NPrinting version.

I appreciate your help!

Re: KPI object is HTML report doesn't shows any data (sometimes)

Frank_S — Tue, 02 May 2023 17:43:28 GMT

@drorelkouby

Also keep in mind that some dashboard and visualization bundle objects native to Qlik are not supported.

For a matrix listing of these visit

Kind regards...

Re: KPI object is HTML report doesn't shows any data (sometimes)

drorelkouby — Tue, 02 May 2023 18:08:03 GMT

Thank you @Frank_S

I've checked the link you sent and I don't see any mention about the single\standard KPI.

I see some restrictions about Multi-KPI but I'm not using those.

It used to work fine until the recent update to QlikSense so I guess it related to that.

For now, I'll try to create my KPI directly in NPrinting instead of importing it, as Lech suggested, and check again after we upgrade our NPrinting version.

Thank again

Dror

Re: KPI object is HTML report doesn't shows any data (sometimes)

drorelkouby — Thu, 04 May 2023 16:49:57 GMT

Thanks again @Lech_Miszkiewicz I was able to create the KPI I wanted, using html and css tags.
I don't know much about HTML as especially css but thanks to the internet (and my stubbornness) I was able to create the KPI I needed. Overall I'm happy with the result

In case someone want to use it in his HTML here is the code I've used:

<html>

<head>

<style>

.icon {

float: right;

font-size:500%;

position: absolute;

top:0rem;

right:-0.3rem;

opacity: .16;

}

#container

{

width: 1200px;

display: flex;

}

.grey-dark

{

background: #495057;

color: #efefef;

}

.red-gradient {

background: linear-gradient(180deg, rgba(207,82,82,1) 0%, rgba(121,9,9,1) 80%);

color: #fff;

}

.red {

background: #a83b3b;

color: #fff;

}

.purple

{

background: #886ab5;

color: #fff;

}

.blue {

background: #3757B4;

color: #fff;

}

.kpi-card

{

overflow: hidden;

position: relative;

box-shadow: 1px 1px 3px rgba(0,0,0,0.75);;

display: inline-block;

float: left;

padding: 1em;

border-radius: 0.3em;

font-family: sans-serif;

width: 240px;

min-width: 180px;

margin-left: 0.5em;

margin-top: 0.5em;

}

.card-value {

display: block;

font-size: 190%;

font-weight: bolder;

}

.card-text {

display:block;

font-size: 100%;

padding-left: 0.2em;

}

</style>

window.console = window.console || function(t) {};

</script>

</head>

<body>

<h2> This is a weekly FSV report (ECP Only) </h2>

See attached Excel file with additional information <br>

<br>

<span class="card-text">%%KPI1title%% </span>

</div>

<span class="card-text">%%KPI2-title%% </span>

</div>

<span class="card-text">%%KPI3-title%%</span>

</div>

</body>

</html>

Re: KPI object is HTML report doesn't shows any data (sometimes)

Lech_Miszkiewicz — Thu, 04 May 2023 22:51:20 GMT

Thanks for sharing - looks good!

One thing to remember is to check compatibility of your code vs email clients you are going to use in case your HTML needs to be embedded in email body. For those scenarios your <script> tags will not work as they are not supported in email clients.

<script>

window.console = window.console || function(t) {};

</script>

cheers

Re: KPI object is HTML report doesn't shows any data (sometimes)

drorelkouby — Fri, 05 May 2023 13:21:24 GMT

Thanks @Lech_Miszkiewicz you were right... it doesn't shows the formatting in the email (just appears as regular text).

The <Script> wasn't needed and I removed it, but now I need to figure out if there is a way to include the formatting in the email. Back to the drawing board... 🙂

Re: KPI object is HTML report doesn't shows any data (sometimes)

Lech_Miszkiewicz — Fri, 05 May 2023 23:42:49 GMT

@drorelkouby Ohh... then another thing is to move all your code in between <body> tags as only that part of code is then moved to HTML embedded email.

Most of your formatting sits in <head> tag. I know it is not a best practice but just copy everything inside <body> and try again

cheers

Re: KPI object is HTML report doesn't shows any data (sometimes)

drorelkouby — Sat, 06 May 2023 00:11:56 GMT

@Lech_Miszkiewicz yeah, this is exactly what I did... spent the entire day optimizing HTML for Office365.

I found out the same thing, that I need to move the entire <style> section to inside the <body>.

Also add to reconfigure the location of each container to a table (and get rid of the container).

I didn't want to change the html report to be as Attachment so I had to make some compromise.

The best results I was able to get are:

This is how it looks when I receive the email in my phone (iPhone), which looks perfect:

This is how it looks when I look at the same email in my Outlook client (PC), which is missing some of the formatting but at least readable:

This is how it looks when I look at the same email in my office365 (outlook web), which almost have all the formatting, minus the shopping cart icon:

I think I can live with that, at least until I'll find the time to mess round with it a bit more.

In case someone wants to look at the final code:

<html xmlns:v="urn:schemas-microsoft-com:vml"> <head> </head> <body> <span> <link rel='stylesheet' href='https://cdnjs.cloudflare.com/ajax/libs/font-awesome/5.12.0-2/css/all.min.css'> <style> .icon { float: right; font-size:500%; position: absolute; top:0rem; right:-0.3rem; opacity: .16; } #container { width: 1200px; display: flex; } .grey-dark { background: #495057; color: #efefef; } .red-gradient { background: linear-gradient(180deg, rgba(207,82,82,1) 0%, rgba(121,9,9,1) 80%); color: #fff; } .red { background: #a83b3b; color: #fff; } .purple { background: #886ab5; color: #fff; } .blue { background: #3757B4; color: #fff; } .kpi-card { overflow: hidden; position: relative; box-shadow: 1px 1px 3px rgba(0,0,0,0.75);; display: inline-block; float: left; padding: 1em; border-radius: 0.3em; font-family: sans-serif; width: 240px; min-width: 180px; margin-left: 0.5em; margin-top: 0.5em; } .card-value { display: block; font-size: 190%; font-weight: bolder; } .card-text { display:block; font-size: 100%; padding-left: 0.2em; } </style> </span> <table> <tr> <th> <div class="kpi-card blue"> <span class="card-value">%%KPI1-1%%<SUP><font size="4">%%KPI1-2%%</font></SUP></span> <span class="card-text"><br>%%KPI1title%% </span> <i class="fas fa-shopping-cart icon"></i> </div> </th> <th> <div class="kpi-card purple"> <span class="card-value">%%KPI2%% <SUP> </SUP></span> <span class="card-text"><br>%%KPI2Title%% </span> <i class="fas fa-shopping-cart icon"></i> </div> </th> <th> <div class="kpi-card grey-dark"> <span class="card-value">%%KPI3-1%%<SUP><font size="4">%%KPI3-2%%</font></SUP></span> <span class="card-text"><br>%%KPI3Title%%</span> <i class="fas fa-shopping-cart icon"></i> </div> </th> </tr> </table> <br> </body> </html>

Re: KPI object is HTML report doesn't shows any data (sometimes)

Lech_Miszkiewicz — Sat, 06 May 2023 01:39:10 GMT

Well done and thanks for sharing the code it helps others!

Outlook on PC (windows) is a piece of #$%@. I am normally working on Mac and most of my coding worked when I was testing only to find out that it is all going to bin once I previewed it on Windows with outlook client.

At the end it is what it is and workaround required to get everything working in all email clients may not be worth the effort.