All Forums

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.

Hello,

I'm running QlikView server and publisher on a windows VM
Our license is renewed successfully as we confirmed with our contact in Qlik customer service management.
However i'm unable to apply the license, i have all the needed info (serial number, control number, LEF, owner information)
LEF should be correct as it was shared by our contact in Qlik.
Also tried to generate it from here with same results https://lef1.qliktech.com/manuallef/default.aspx

Tried restarting the QlikView windows services many times and applying the license again with no success.
worth noting the license for publisher is working fine with no issues.

Thanks in advance for any help or advise

Hi Team,

Is there a supported way to automate updating the SMTP password in Qlik NPrinting?

I noticed that the password is stored in encrypted form in the SMTP configuration, so directly updating it is not straightforward.

Due to our organization's password rotation policy, we need to update the SMTP password regularly without manual intervention. Is there any supported approach, such as a PowerShell script, REST API, or command-line utility, to automate this process?

We are currently using Qlik NPrinting February 2024.

Any guidance or best practices would be greatly appreciated.

Thanks and regards,

Irshad Ahmad

Hello @Sonja_Bauernfeind 

Can you please confirm that the compatibility for NPrinting from February 2025 to May 2026 is the same?

The following page needs to be fixed anyway 😄

System requirements for Qlik NPrinting Engine | Qlik NPrinting Help

Regards,

Hello
got 3 dimensions in my Qlik sense app:
Month, currency, scenario
I want to create the follwing simple report:

MONTH        CURRENCY        SCENARIO
202601          EUR                    ACTUAL
202601          USD                    ACTUAL
202601          EUR                    BUDGET
202601          USD                    BUDGET

202602          EUR                    ACTUAL
202602          USD                    ACTUAL
202602          EUR                    BUDGET
202602          USD                    BUDGET
...

I create 3 levels in Nprinting report editor as follows:

Now I want to use these in the excel sheet:
which I used as follows:

and the result is not as expected:

kindly advise on how to put the levels on the excel template
@Lech_Miszkiewicz 

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.

Hi, there

We have Qlik Sense Enterprise on server. I connect to the hub on my laptop using wifi of my mobile phone.  Everything in my app is working ok except map. There is no map layer. Seems like there's no internet connection at all.

When copying the app to the QS desktop - map is working ok using mobile internet connection.
When connecting to the server via rdp - map is working ok using mobile internet connection.
I tried use 4G wifi router - the same problem.

Had someone had the same problem?

I want to share something I experienced today.

I was dealing with a NPrinting migration, and during the data connection validation, I was getting "A supported version of QlikView Desktop is installed" even though everything was installed.

Initially, I got the license check mark to be red as well; then I successfully leased a license, and it went away, leaving me with the supported version failure.

I've tried installing greater versions of QlikView Desktop and got the same results (even knowing it needs to be the same version of QVS).

What I learned is: Reboot the machine after installing QlikView Desktop.

I hope that helps.

Qlik NPrinting QlikView