All Forums

Hello Team,

I am facing an issue with Qlik N-Printing.

Environment:

- N-Printing Version: 19.x

- Engine Server: lvqlikdev03

Issue:
The Engine status is showing Offline in N-Printing Admin Console.
Observed Behavior:
The Engine service starts and immediately stops.
Engine Log:
Starting up Engine service
Certificates exchange HTTP server listening on http://localhost:4997/
Stopping Engine service
Engine service stopped

Could anyone advise how to bring the Engine online.

Thank you.

Hi All,

I've noticed that after the reload of today that a lot of records are not loaded in the dashboard.

The selection is the same as the previous days and also the file was available.

This is a part of the log of Yesterday.

I load 2 files in the table.

In the first file are 33,598,635 records.

The second file 56,329,459 - 33,598,635 = 22,730,824 records.

33,598,635 lines fetched
20260903T112456.545+0200 1230 next
20260903T112456.546+0200 1180 let vFile = 'TRX_H_' & 2026 & '.QVD'
20260903T112456.550+0200 1181 concatenate
20260903T112456.550+0200 1182 TRX_H:
20260903T112456.550+0200 1183 LOAD
20260903T112456.550+0200 1184 AutoNumber(TRX_H_TYPE & TRX_H_DTME & TRX_H_DTMJ & TRX_H_DTMM & TRX_H_DTMD & TRX_H_UURT & TRX_H_STNR & TRX_H_REF & TRX_H_SEQ,'Key_TRXD') as Key_TRXD,
20260903T112456.550+0200 1185 AutoNumber(TRX_H_TYPE & TRX_H_DTME & TRX_H_DTMJ & TRX_H_DTMM & TRX_H_DTMD & TRX_H_UURT & TRX_H_STNR & TRX_H_REF & TRX_H_SEQ,'Key_TRXF') as Key_TRXF,
20260903T112456.550+0200 1186
20260903T112456.550+0200 1187
20260903T112456.550+0200 1188
20260903T112456.550+0200 1189
20260903T112456.550+0200 1190
20260903T112456.550+0200 1191 num(makedate(TRX_H_DTME & num(TRX_H_DTMJ,'00'),TRX_H_DTMM,TRX_H_DTMD)) as Datumtransactie,
20260903T112456.550+0200 1192
20260903T112456.550+0200 1193 if(0 = 1,
20260903T112456.550+0200 1194 Applymap('PBY_Map',num(TRX_H_STNR,'00000') & Left(num(TRX_H_REF,'0000000000'),4),num(Today())),
20260903T112456.550+0200 1195 num(makedate(TRX_H_DTME & num(TRX_H_DTMJ,'00') ,TRX_H_DTMM , TRX_H_DTMD))) as DatumNum,
20260903T112456.550+0200 1196
20260903T112456.550+0200 1197
20260903T112456.550+0200 1198 Left(num(TRX_H_UURT,'000000'),2) & ':' & Mid(num(TRX_H_UURT,'000000'),3,2) as Uur_Getankt,
20260903T112456.550+0200 1199
20260903T112456.550+0200 1200 Left(num(TRX_H_UURT,'000000'),2) as Uur,
20260903T112456.550+0200 1201 Left(num(TRX_H_UURT,'000000'),2) & ':' & mid(num(TRX_H_UURT,'000000'),3,2) & ':' & left(num(TRX_H_UURT,'000000'),2) as UurSec,
20260903T112456.550+0200 1202 num(TRX_H_STNR,'00000') as Stationnummer,
20260903T112456.550+0200 1203
20260903T112456.550+0200 1204
20260903T112456.550+0200 1205
20260903T112456.550+0200 1206 if(TRX_H_SHF=0, 'Terminal', TRX_H_SHF) as Shift_Id,
20260903T112456.550+0200 1207 TRX_H_STNR & '-' & if(len(trim(TRX_H_OPID)) = 0 or TRX_H_OPID = ' ' ,'Terminal', trim(TRX_H_OPID)) as Operator_Id,
20260903T112456.550+0200 1208 if(len(trim(TRX_H_OPID)) = 0 or TRX_H_OPID = ' ' ,'Terminal', 'Shop') as Terminal_Shop,
20260903T112456.550+0200 1209
20260903T112456.550+0200 1210
20260903T112456.550+0200 1211
20260903T112456.550+0200 1212
20260903T112456.550+0200 1213 TRX_H_CUST as KeyCust,
20260903T112456.550+0200 1214 if(len(trim(TRX_H_ID)) > 0,TRX_H_ID, TRX_H_PAN) as Firmakaart,
20260903T112456.550+0200 1215 'KL' & num(TRX_H_CUST,'00000') as Klant_Lev_Nummer,
20260903T112456.550+0200 1216 applymap('KLANT_MAP', 'KL' & num(TRX_H_CUST,'00000'),'UNKNOWN') as Klant_Naamtest,
20260903T112456.550+0200 1217 TRX_H_PAN,
20260903T112456.550+0200 1218
20260903T112456.550+0200 1219 TRX_H_ODO as Km_Stand,
20260903T112456.550+0200 1220
20260903T112456.550+0200 1221 TRX_H_CARR as Plaatnummer,
20260903T112456.550+0200 1222 TRX_H_TTNA as TRXHTotal
20260903T112456.550+0200 1223 FROM
20260903T112456.550+0200 1224 [..\03_QVD\TRX_H_2026.QVD]
20260903T112456.550+0200 1225 (qvd)
20260903T112456.550+0200 1226 where num(makedate(TRX_H_DTME & num(TRX_H_DTMJ,'00'), TRX_H_DTMM,TRX_H_DTMD)) >= 45658 and len(trim(TRX_H_STNR)) > 0 and TRX_H_STNR <= '1000'
20260903T112456.555+0200 19 fields found: Key_TRXD, Key_TRXF, Datumtransactie, DatumNum, Uur_Getankt, Uur, UurSec, Stationnummer, Shift_Id, Operator_Id, Terminal_Shop, KeyCust, Firmakaart, Klant_Lev_Nummer, Klant_Naamtest, TRX_H_PAN, Km_Stand, Plaatnummer, TRXHTotal,
20260903T114353.975+0200 56,329,459 lines fetched

This is the a part of the log of the reload of today.

Also in the first file I have less records then the day before (it should be more)

And in the second file I have almost no records loaded.

30,883,385 lines fetched
20260904T062431.542+0200 1230 next
20260904T062431.559+0200 1180 let vFile = 'TRX_H_' & 2026 & '.QVD'
20260904T062431.590+0200 1181 concatenate
20260904T062431.590+0200 1182 TRX_H:
20260904T062431.590+0200 1183 LOAD
20260904T062431.590+0200 1184 AutoNumber(TRX_H_TYPE & TRX_H_DTME & TRX_H_DTMJ & TRX_H_DTMM & TRX_H_DTMD & TRX_H_UURT & TRX_H_STNR & TRX_H_REF & TRX_H_SEQ,'Key_TRXD') as Key_TRXD,
20260904T062431.590+0200 1185 AutoNumber(TRX_H_TYPE & TRX_H_DTME & TRX_H_DTMJ & TRX_H_DTMM & TRX_H_DTMD & TRX_H_UURT & TRX_H_STNR & TRX_H_REF & TRX_H_SEQ,'Key_TRXF') as Key_TRXF,
20260904T062431.590+0200 1186
20260904T062431.590+0200 1187
20260904T062431.590+0200 1188
20260904T062431.590+0200 1189
20260904T062431.590+0200 1190
20260904T062431.590+0200 1191 num(makedate(TRX_H_DTME & num(TRX_H_DTMJ,'00'),TRX_H_DTMM,TRX_H_DTMD)) as Datumtransactie,
20260904T062431.590+0200 1192
20260904T062431.590+0200 1193 if(0 = 1,
20260904T062431.590+0200 1194 Applymap('PBY_Map',num(TRX_H_STNR,'00000') & Left(num(TRX_H_REF,'0000000000'),4),num(Today())),
20260904T062431.590+0200 1195 num(makedate(TRX_H_DTME & num(TRX_H_DTMJ,'00') ,TRX_H_DTMM , TRX_H_DTMD))) as DatumNum,
20260904T062431.591+0200 1196
20260904T062431.591+0200 1197
20260904T062431.591+0200 1198 Left(num(TRX_H_UURT,'000000'),2) & ':' & Mid(num(TRX_H_UURT,'000000'),3,2) as Uur_Getankt,
20260904T062431.591+0200 1199
20260904T062431.591+0200 1200 Left(num(TRX_H_UURT,'000000'),2) as Uur,
20260904T062431.591+0200 1201 Left(num(TRX_H_UURT,'000000'),2) & ':' & mid(num(TRX_H_UURT,'000000'),3,2) & ':' & left(num(TRX_H_UURT,'000000'),2) as UurSec,
20260904T062431.591+0200 1202 num(TRX_H_STNR,'00000') as Stationnummer,
20260904T062431.591+0200 1203
20260904T062431.591+0200 1204
20260904T062431.591+0200 1205
20260904T062431.591+0200 1206 if(TRX_H_SHF=0, 'Terminal', TRX_H_SHF) as Shift_Id,
20260904T062431.591+0200 1207 TRX_H_STNR & '-' & if(len(trim(TRX_H_OPID)) = 0 or TRX_H_OPID = ' ' ,'Terminal', trim(TRX_H_OPID)) as Operator_Id,
20260904T062431.591+0200 1208 if(len(trim(TRX_H_OPID)) = 0 or TRX_H_OPID = ' ' ,'Terminal', 'Shop') as Terminal_Shop,
20260904T062431.591+0200 1209
20260904T062431.591+0200 1210
20260904T062431.591+0200 1211
20260904T062431.591+0200 1212
20260904T062431.591+0200 1213 TRX_H_CUST as KeyCust,
20260904T062431.591+0200 1214 if(len(trim(TRX_H_ID)) > 0,TRX_H_ID, TRX_H_PAN) as Firmakaart,
20260904T062431.591+0200 1215 'KL' & num(TRX_H_CUST,'00000') as Klant_Lev_Nummer,
20260904T062431.591+0200 1216 applymap('KLANT_MAP', 'KL' & num(TRX_H_CUST,'00000'),'UNKNOWN') as Klant_Naamtest,
20260904T062431.591+0200 1217 TRX_H_PAN,
20260904T062431.591+0200 1218
20260904T062431.591+0200 1219 TRX_H_ODO as Km_Stand,
20260904T062431.591+0200 1220
20260904T062431.591+0200 1221 TRX_H_CARR as Plaatnummer,
20260904T062431.591+0200 1222 TRX_H_TTNA as TRXHTotal
20260904T062431.591+0200 1223 FROM
20260904T062431.591+0200 1224 [..\03_QVD\TRX_H_2026.QVD]
20260904T062431.591+0200 1225 (qvd)
20260904T062431.591+0200 1226 where num(makedate(TRX_H_DTME & num(TRX_H_DTMJ,'00'), TRX_H_DTMM,TRX_H_DTMD)) >= 45658 and len(trim(TRX_H_STNR)) > 0 and TRX_H_STNR <= '1000'
20260904T062431.629+0200 19 fields found: Key_TRXD, Key_TRXF, Datumtransactie, DatumNum, Uur_Getankt, Uur, UurSec, Stationnummer, Shift_Id, Operator_Id, Terminal_Shop, KeyCust, Firmakaart, Klant_Lev_Nummer, Klant_Naamtest, TRX_H_PAN, Km_Stand, Plaatnummer, TRXHTotal,
20260904T062456.643+0200 31,170,105 lines fetched

Who has an idea why he is not loading all data?

The data is the transaction header out of a shop. So every day there should be more records.

If I doe now a reload of the trx_h_2026 with the same selections in my desktop, this is the result.

Who can help me with this?

Hi,

I am using NPrinting Feb 2025 SR5, I installed and configured myself and it was working well for months now, my IT recently turned off Internet on this server where NPrinting is installed and have configured a proxy server for Internet via some port.

Now when I got my internet back and using some host entry got NPrinting to work and resolve license verification using - 
54.200.236.202 license.qlikcloud.com
98.91.13.249 license.qlikcloud.com
10.210.248.121 license.qlikcloud.com

Now my connection isn't getting done correctly, I have recreated and installed certificates many times now from QlikSense to NPrinting using IP and FQDN but still getting error at certificate part.

Please let me know how to resolve it ASAP. @QFabian @PrashantSangle @Nicole-Smith 

Hi,

We have QlikView Server and QlikView Desktop installed on a Windows Server 2022 machine, which we access via Remote Desktop.

Earlier this year, I upgraded our QlikView installation from May 2023 to September 2025 SR1. After the upgrade, I noticed that QlikView Desktop had become extremely slow and unresponsive.

When QlikView Desktop is started, the menus and the application itself initially seem to work normally. However, as soon as I open a QlikView document, the application becomes very sluggish. On AccessPoint everything works fine.

For example:

- Clicking the QlikView > About menu can take 2–4 seconds before anything happens.
- Right-clicking an object on a report can take several seconds before the context menu appears.
- Scrolling in list boxes is very jerky and noticeably delayed.
- In general, there is a significant delay between clicking something and QlikView responding.

At the time, I did not have time to investigate the issue further.

Today I uninstalled QlikView Desktop and installed the May 2023 version again. The performance immediately returned to normal. When clicking objects or menus in a QlikView document, everything responds almost instantly.

I then upgraded QlikView Desktop to May 2024 SR1, and the performance was still normal.

After that, I upgraded to September 2025 IR, and the performance problem immediately returned.

So far, my testing looks like this:

- May 2023: Good performance
- May 2024 SR1: Good performance
- September 2025 IR: Very slow / significant UI delays
- September 2025 SR1: Very slow / significant UI delays
- September 2025 SR2: Very slow / significant UI delays

I have also disabled the antivirus temporarily, but this did not make any difference.

Has anyone else experienced similar QlikView Desktop performance or UI responsiveness issues with the September 2025 releases?

After generating a report on Nprinting, I realized that some of the objects are not present in the final PDF file. Specifically container objects, which I use to group together several objects in an organized way. This happens rather randomly, meaning that it has happened for some containers one day and for others in some other day, both on local and on server (Testing).

I would greatly appreciate any advice on how to solve this matter.

Thank you all in advance.

Regards.

I have struggled with this for a while. Having read the Nprinting docs and gone through the 'what to do when dollar sign expansion doesn't work' and it still appears to not be working. I have other reports built in Nprinting that work well, this is the first I've tried to use Qlik Sense Variables in.

Nprinting version: Qlik NPrinting May 2026 Version: 26.19.3.0

Qlik Sense Enterprise November 2025.

Scenario: I have several variables in my Qlik Sense App: vCSDReportName, vCSDPeriodStart, vCSDPeriodEnd.

3 Variable Input objects

I have added them to my template as so:

3 variables in Template

I have created a variable filter thusly:

variable selected and value set.

And yet when I run a preview of the report in design mode I get this:

Nothing comes across..

 I've read through this article: https://community.qlik.com/t5/Qlik-NPrinting/Setting-variable-in-Nprinting-report/td-p/2496221 several times and I simply don't understand what I am missing.

If anyone can shed light on my ignorance I'd greatly appreciate it!

Hello Qlik Community,

I'm encountering an unexpected behavior with FirstSortedValue and would appreciate your insights.

Context:
I have a table tracking employee appointments with fields:

• EmployeeID (id_dim_salarie)

• VisitID (id_visite_unique)

• DateTime (date_consultation) - numeric Excel datetime

• Teleconsult (teleconsultation) - text field ("Oui"/"Non")

Goal:
For each employee, retrieve the Teleconsult value from their latest appointment (maximum DateTime).

Expression used:

Sample data (attached: Data_exploration.xlsx):

Expected result for EmployeeID 1000011682:

• Latest date: 2025-07-22 10:15:00.000 (Excel numeric: 45860.4270833333)

• Teleconsult value at that date: "Oui"

• Should return: "Oui"

Actual result: NULL

Debug information I've verified:

1. Max(date_consultation) = 45860.4270833333 ✓ (correct latest date)

2. Count(DISTINCT date_consultation) = 2 ✓ (two distinct dates)

3. Count(teleconsultation) = 2 ✓ (both lines have valid "Oui" values)

4. No NULL values in teleconsultation for this employee ✓

5. Dates are properly loaded as numeric datetime values 

According to the documentation, FirstSortedValue should return NULL only when "more than one resulting value shares the same sort_weight for the specified rank". Here I have a unique maximum date with a valid teleconsultation value.

Why does this expression return NULL? Is there something about the numeric datetime format or the specific context that's causing this behavior?

In case so, can you please share your experience?

I'm working with a multinode environment (1x QVS + 3x QVP) where I think I might need to move to Microsoft SQL Server.

Can you please share the pros/cons?

Regards,

Hi ,

Can anyone please share the following:

White Paper - QlikView Metadata Management.pdf  or any information regarding Metadata

Regards,

Gargi                                       

I need some assistance in locating the Geo Analytics license linked to the Qlik Sense license.

I am installing the tool to enable the connector and import custom maps.