All Forums

Hi everyone,

got a column with phone numbers and used the following

       KeepChar(Replace(Phone, 'O', '0'), '0123456789') AS %KEY_Phone_Bill

to remove special characters

But I would also like to clean the country code, which is part of some but not all entries. This looks like this:

0049170123456

49170123456

490170123456

0170123456

170123456

The only correct way I would like to keep is 0170123456

So I thought I check if the number begins with 00 oder 490 and replace them with 0. Could I use the replace() with $ or something that indicated I want only replace at the beginning of the string. Or do I need to use regex?

2nd step I would check if any string does not start with a 0, so place a 0 in front of the string.

Or is there an easier way to do this?

Hi,

A customer is trying to build a QlikEntity Report from Qlik Sense on prem, but can't seem to find the object id in the list of the available objects.

It looks like there is a hard limit on how many objects the interface can show in the drop down menu when creating the report, and we're not able to search for anything beyond the last value in the list.

e.g. in the screenshot you can see the list ends with object id "8*******" something, but we know as a fact from the application interface that we have many object ids starting with "c****".

Do you know of any such limitation? How can we work around this limit?

Hi everyone,

Does anyone can point me to some documentation, extension or strategy on how to perform a heat map on a 96 well plate (8x12 table). I attached example of the well map that I do in R with a data table. To give some context, we are performing an assay in a 96 well plate which is like a 8x12 table. I would like to identify pattern due to process failure. The data table will be a list of plate ID with all the coordinate and value, the list of plate will be shown in a table then when a plate is clicked the heat map will be shown.

The reported data look like this:

Many thanks,

Christian

Nessus vulnerability scanner shows in results:

"Microsoft Microsoft XML Core Servies 3.0 (C:\Windows\System32\Msxml3.dll)"
This component is no longer supported by MS

We have removed these files:
C:\Windows\System32\msxml3.dll
C:\Windows\System32\msxml3r.dll

After this we cannot move any objects in the QlikView Desktop

Hello.

We are building an app (using the Cloud SaaS version) with the following characteristics:

- we have an input dashboard in which the user select one or more fields from the available dimensions in the Qlik Sense app and then click a trigger button passing as parameters the current state of the selection.

- the button triggers an automation that writes the log in our Postgres DB where an elaboration takes place

- finally our elaboration store the data related to the elaboration in a Postgres table along with a SESSION ID and the USER ID (user id on Qlik Sense) that made the request.

- after completion our script calls via POST a Qlik Automation that reload the data on our app so that the user can see the result of the elaboration.

- at the moment in the loading script we load the latest 5 elaboration made by users and give the user the possibility to switch from one elaboration to another one (workaround to avoid different users overriding their elaboration).

Now, we want to optimize loading times since a FULL Load takes 1 minute to load all the latest 5 elaboration + the available dimensions. 

For this reason we tried to implement the Partial Reload. Idea was:

- every day make a full reload with the latest 5 elaboration

- every time the user SUBMITS a new request it triggers only a partial reload that loads only the latest session.

We're currently having an issue though with consecutive partial reload, for instance the first partial reload is working fine adding the newest session to the latest 5 (loaded during the FULL), but the consecutive partial reloads will load the newest session keeping the 5 sessions loaded during the daily full but LOSING the other partial reloads performed during the day.
Example: during full sessions 1,2,3,4,5 are loaded. Then first user submit a requests, on qlik I find the data for sessions 1,2,3,4,5 and 6. When another user submits, the latest is loaded and on qlik i find sessions 1,2,3,4,5 and 7 (session 6 is lost).

We currently don't understand if this is an error in the script or if the functionality is supposed to work like this. Could you please give advice on how to achieve the intended behaviour?

This is the Script:

LIB CONNECT TO 'connector';

// Full Reload: load all sessions
IF NOT IsPartialReload() THEN
  Forecast:
  LOAD
      data...  ;
  // Load data directly from postgres DB Table
  SQL SELECT
      data...;
  FROM table_name
  WHERE session_id >= (SELECT MAX(session_id) - 3  from table_name);

END IF

// Partial Reload case
IF IsPartialReload() THEN
    ADD LOAD
        data... ;
    SQL SELECT
        data... ;
    FROM table_name
    WHERE session_id = (
        SELECT MAX(session_id)
        FROM table_name
    );

END IF

Thanks in advance

Andrea

Hi All,

I'm setting up new Server for NPrinting as my old server was on Windows 2016.

I'm trying to install .net 4.8 in new Server,it doesn't have Nprinting Server/Engine installed.

I'm getting error while installing the .net framework 4.8 for windows 2019 server

 Error message: 0x80092004 -can not find object or property

Can anyone suggest what could be the issue?

Error is attached.

Thanks in advance

Qlik NPrinting  

Quick post to address some common questions regarding the PostGreSQL version included within Qlik NPrinting.

There is an upcoming Qlik NPrinting service release (SR) that will be available before the end of May to move to PostGreSQL V13.20 which will address an identified CVE. There will be SR's released on the February 2024 and February 2025 versions.

The next planned SR will be targeted for end of summer (late August/early September) and it will contain the full PostGreSQL upgrade to Version 17. This will also be available for February 2024 and February 2025 release lines.

Important note 
• Once a version of Qlik NPrinting with a higher version of PostGreSQL is deployed (e.g. from February 2024), you cannot go back to a lower version of the February 2025 version line. Customers should always deploy the latest SR in any Qlik NPrinting version line.
• When these SR's are available, please reference the available Release Notes for a complete list of updates for the associated Qlik NPrinting version

Hello!

Im having a problem trying to fetch the information of points with the "Load" function of GeoAnalytics.

In this case, for the "populated locality" (PPPL)

The thing is, for countries like Spain, which has 23k points for that configuration, there is no problem as it has less than 50000, but for countries like France which have more than 50k points, im not being able to get the information.

The query im using is:

SQL SELECT
*
FROM Load(dataset='Dataset')
DATASOURCE Dataset LOCATIONSERVICE geometry='POINT', type = 'PPPL', country='FR', serviceName='default'

I get that I cannot get more than 50000 points at a time, but is there any way to get the information for France in multiple steps? maybe with another parameter i can use or a LIMIT/TOP 50000 rows? That way i can just do a loop and get the information in multiple steps.

Attached is and image of the error.

Thanks a lot in advance!

Hi,
I'm trying to set up Qlik GeoAnalytics, but I'm having trouble validating the license key.
I configured the proxy used in our establishment by specifying it in the ServerSettings.xml file.

After restarting the service, I see a message confirming that the proxy is being used for license backend communication.
However, when attempting to connect to the license server, it returns: "Connect timed out, retrying."
I also checked the network traffic and noticed that it’s not actually using the proxy as configured.

Am I missing something in the configuration?

Thank you in advance for your help!

I was wondering if there is anyway to manage the user additions and removals with an AD Group,

I know there is a checkbox that can automatically add a user if they try to connect.

But i would like to able to manage Qlikview with an AD Group so that this can automatically be controlled.

Hi,

We have reinstalled Nprinting server, everything works fine except of import users from LDAP. I use the same setting as on previous Nprinting server, but this time receive issue:  

ERROR: 000004DC: LdapErr: DSID-0C0907C2, comment: In order to perform this operation a successful bind must be completed on the connection., data 0, v2580 ---> An operations error occurred.

Please let me know how can I solve it

Thanks,

Vitalii

We upgraded Qlik NPrinting to May 2023 SR3 in DEV Environment and we can see after the upgrade only Import task were failing.

Import tasks were created to import users from LDAP Connection. Same connections were working fine before the upgrade.

No issues with username and password as we were using same credentials to fetch users in PROD NPrinting also.

Hello everyone !

I'm trying to calculate the total number of hours that fall within a specific time window ( between 00:00 and 06:00 ) across a time range defined by two timestamps in Qlik Sense.

For example, suppose I have the following timestamps :

StartTime: 2025-04-20 22:00:00

EndTime: 2025-04-21 08:00:00

I want to calculate how many hours between these two timestamps fall specifically within the 00:00 to 06:00 window. In this case, the answer should be 6 hours, since the entire window from 00:00 to 06:00 on 2025-04-21 is covered by the interval.

Another example:

StartTime: 2025-04-20 05:00:00

EndTime: 2025-04-20 07:00:00

Here, the overlap with the 00:00–06:00 window is only from 05:00 to 06:00, so the expected result would be 1 hour.

Does anyone know how this kind of calculation can be done in Qlik Sense (script or chart expression) ?

Thanks in advance for your help!

Hello Everyone,

I am new here and I need your help please,

sorry for asking this question in this forum butI need some help,

I run my business and after settling it , I'm looking for best mobile app development firm for my business’s App. I want an amazing and attractive App for my business in my not so big budget. I found some reputed app development company on Google “Creative27, Apptology, iMOBDEV Technologies, Click Labs and QBurst” but I m confused which one to select for my App building. If anyone have ever worked with any app development company, then please share your experience with me.