All Forums

Good morning! 
I would like to know if ICAO code 'OJMS' exists in version February 2024 of the QlikGeoAnalytics?  Does this version: February 2024 (5.38.2) 2023-02-05 have this airport?

Thank you in advance!

Hi All, 

I 'm facing the above error since a few days.Nothing has changed only Windows patches on Monday

We have checked all normal issues like port 4747, credentials, rights etc. 
QVS service is running. 

The Management Service Log shows this:

0260423T154535.010+0200    Error    System.Exception: Failed to retrieve settings from QlikView Server. ||    at QMSBackendCore.Service.ServiceImpl.<>c__DisplayClass94_0.<UpdateQvsSettingsCache>b__0() ||    at SolutionGlobal.Collections.ThreadSafeCache`2.CacheItem`1.GetObject() ||    at SolutionGlobal.Collections.ThreadSafeCache`2.Get(TKey key, Func`1 createObjectFunc) ||    at QMSBackendCore.Service.ServiceImpl.UpdateQvsSettingsCache(Guid qvsID) ||    at QMSBackendCore.Service.ServiceImpl.Diagnostics.UpdateQvsSettingsCache()

Any suggestions? 

Jan 

Hi All,

I am using On-Demand Reporting button to generate Nprinting report in PPTX format. The downloaded ppt is generated with missing legends and objects and the issue is not always with the same chart/slide.

In one download, the object/legend missing and in another download, it is generated without any issues. The issue is not consistent. Below is the screenshot from the generated report.

Regards,

Leni Balakrishnan

Hello, community!

I have this filter chart, and my supervisor isn't happy with the spacing between it and the chart below. I've already tried changing the grid spacing in the folder, but without success. Does anyone have any tips or solutions to align the filters with the charts?

Hi All,

In Nprinting, I am using one of the chart as image and there is no filters applied in the Nprinting level. But the generated report is having the bar chart different from the actual bar chart.

In the actual bar chart, the date selection is ignored using set analysis whereas the generated chart via Nprinting considers the date selection in turn we found mismatch between Dashboard chart and Nprinting report.

Set Analysis used as below in chart,

Count({<Date=>}distinct Product)

Leni Balakrishnan

I keep getting an error message when trying to access the latest version of QlikView Power Tools...  https://community.qlik.com/t5/Documents/Power-Tools-1-3-2-for-QlikView/ta-p/1484770

Does anyone have an alternative link?

Hello, most of the posts that I am finding in regard to my current issue point to this article:

support.qlik.com/articles/000007290

but anything on support.qlik.com is currently giving me errors. Is someone able to reply with the content of that article, or the relevant details?

Thanks

I am a beginner in NPrinting and I need some guidance.

I have created a report that needs to be sent to 20 recipients. Each recipient should receive a version of the report filtered by their specific zone. The zones already exist in a Qlik Sense table, and I have successfully set up the filters.

My question is: how can I dynamically include the zone name in the following elements:
- The report header (to display the zone value)
- The email subject when sending the report
- The report file name (if possible)

The main challenge for me is not the filtering itself, but how to inject the corresponding zone value dynamically into these elements for each recipient.

Any help would be greatly appreciated.

Hello,

We have a growing number of customers who rely on Qlik NPrinting for their email reporting distribution via Office 365 (Exchange Online).

As many of you know, Microsoft has been proactively disabling Basic Authentication for SMTP AUTH, with a final deadline for full retirement currently set for April 2026.
Exchange Online to retire Basic auth for Client Submission (SMTP AUTH) | Microsoft Community Hub

Since NPrinting currently only supports Basic Authentication for its built-in SMTP connection, this presents a significant problem for many organizations.

The Problem

• NPrinting currently does not support OAuth 2.0 (Modern Authentication) for connecting to smtp.office365.com.

• As Microsoft retires Basic Auth, our current reporting setup for many customers will break entirely.

My Questions for the Community & Qlik

1. Is there any official roadmap information regarding the implementation of OAuth 2.0 / Modern Authentication for NPrinting's SMTP configuration?

2. What is the long-term, supported strategy for Qlik NPrinting to connect to Microsoft 365 mailboxes for report distribution?
   
   Qlik NPrinting

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?

=AGGR(MAX([Item'LANDED']), [Item Barcodes],[Stock-Bez])

=SUM( IF(MATCH([BESTAND RECHNEN METHODE],'AM-DATUM') AND MATCH(DATE(Datum),MONTHEND(TODAY(1),-1)), [Menge BES (Bestand)] * [Artikel 'LANDED'],