Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Recent Discussions
-
Microsoft retires SMTP Basic Auth
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... Show MoreHello,
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 HubSince 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
Is there any official roadmap information regarding the implementation of OAuth 2.0 / Modern Authentication for NPrinting's SMTP configuration?
What is the long-term, supported strategy for Qlik NPrinting to connect to Microsoft 365 mailboxes for report distribution?
Qlik NPrinting
-
Export and Import Objects from one Qlikview file to another Qlikview file.
Hello Everyone,I needed help in exporting single/all objects from one qlikview(.qvw) file to another Existing qlikview(.qvw) file.The imported object ... Show MoreHello Everyone,
I needed help in exporting single/all objects from one qlikview(.qvw) file to another Existing qlikview(.qvw) file.
The imported object should get appended to new sheet i.e. the existing objects on the file should not get deleted.
Is there any way out?
Please help.
Regards,
Pratik
-
Copy Object from One Qlikview Instance to Another
I have pivot table which was created in one of the earlier versions of Qlikview file and somehow got removed in subsequent version.I need that pivot t... Show MoreI have pivot table which was created in one of the earlier versions of Qlikview file and somehow got removed in subsequent version.
I need that pivot table back in the latest version but I was not able to copy the pivot table object. I was able to create export file (QVO file) for the object. How could that file be imported into the latest version where I need the object to be?
-
Within operation example
Hi all, I have used the examples from Connector Examples Qlik GeoAnalytics - Qlik Community - 1548148 and was able to run them fine. The code block th... Show MoreHi all,
I have used the examples from Connector Examples Qlik GeoAnalytics - Qlik Community - 1548148 and was able to run them fine. The code block that gets generated after successful completion of within operation is :
data:
load * Inline [
id,lat,lon
1,25.8587,-80.2094
10960,31.1073,-97.7479
22821,42.6722,-83.1335
];LIB CONNECT TO 'GA';/* Generated by GeoAnalytics for operation Within ---------------------- */[_inlineMap_]:mapping LOAD * inline [_char_, _utf_"'", '\u0027''"', '\u0022'"[", '\u005b'"/", '\u002f'"*", '\u002a'";", '\u003b'"}", '\u007d'"{", '\u007b'"`", '\u0060'"´", '\u00b4'" ", '\u0009'];IF FieldNumber('id', 'data') = 0 THENcall InvalidInlineData('The field id in data is not available');END IFIF FieldNumber('lat', 'data') = 0 THENcall InvalidInlineData('The field lat in data is not available');END IFIF FieldNumber('lon', 'data') = 0 THENcall InvalidInlineData('The field lon in data is not available');END IFLet [ptsInlineTable] = 'id' & Chr(9) & 'lat' & Chr(9) & 'lon';Let numRows = NoOfRows('data');Let chunkSize = 1000;Let chunks = numRows/chunkSize;For n = 0 to chunksLet chunkText = '';Let chunk = n*chunkSize;For i = 0 To chunkSize-1Let row = '';Let rowNr = chunk+i;Exit for when rowNr >= numRows;For Each f In 'id', 'lat', 'lon'row = row & Chr(9) & MapSubString('_inlineMap_', Peek('$(f)', $(rowNr), 'data'));NextchunkText = chunkText & Chr(10) & Mid('$(row)', 2);Next[ptsInlineTable] = [ptsInlineTable] & chunkText;NextchunkText=''[WithinAssociations]:SQL SELECT [pts_county_RelationId], [id], [LocationDbId] FROM Within(enclosed='pts', enclosing='county')DATASOURCE pts INLINE tableName='data', tableFields='id,lat,lon', geometryType='POINTLATLON', loadDistinct='NO', suffix='', crs='Auto' {$(ptsInlineTable)}DATASOURCE county LOCATIONSERVICE geometry='AREA', type='AADM2', country='US', serviceName='default'SELECT [LocationDbId], [county_Geometry], [county_Name] FROM county;[county]:SQL LOAD * FROM county;tag field [pts_county_RelationId] with '$primarykey';tag field [LocationDbId] with '$primarykey';tag field [county_Geometry] with '$geopolygon';tag field [LocationDbId] with '$geoname';tag field [county_Geometry] with '$relates_LocationDbId';tag field [LocationDbId] with '$relates_county_Geometry';[ptsInlineTable] = '';/* End GeoAnalytics operation Within ----------------------------------- */In this code, if i want to add my own kml file or shapefile(zip) from local folder, how do i edit this?For example the kml file after loading looks like:MyKML:
LOAD
Agniyar.Name,
Agniyar.Area
FROM [lib://Local_E_Drive /Water_resources/Riverbasin.kml]
(kml, Table is [Riverbasin/Riverbasin]);I also would like to know if instead of inline table load, if we add an excel or csv files how the above code will get changed? -
Importing NPrinting template to new report but using a different connection
Hello,I currently have an existing PPT report using Connection "XYZ", but I would like to create a new report using the same template created from the... Show MoreHello,
I currently have an existing PPT report using Connection "XYZ", but I would like to create a new report using the same template created from the existing report.
I tried to export this as a zip, then proceed to import the report. This seems to work ONLY if they share the same connection, but in my case I want to use a different connection (the same objects exist in both apps).
Another workaround I tried was to go to the C:\ProgramData folder and locate the PPT template used, and then create a brand new report and using this template file. But I lose all the information I had in the existing report, via the variables, Formulas, and tables used.
Any ideas how I can go about this? Or do I have to use the same connection.
I am using Qlik NPrinting April 2019 with QlikView 12.20.
-
Unable to change the NPrinting connection when importing a PowerPoint report
Hello everyone,I’m encountering a behavior in Qlik NPrinting that I don’t fully understand, and I’d like to know whether it is expected or if I’m miss... Show MoreHello everyone,
I’m encountering a behavior in Qlik NPrinting that I don’t fully understand, and I’d like to know whether it is expected or if I’m missing something.
Here is the situation
I export a report from N Printing
Then I import it into another Nprinting App with another connection
it is well working with Excel reports, I am able to change the App and assign a new Connection without any issue
However: with power point, NPrinting does not allow me to change the connection when importing the report.
For context:
I duplicated the original Qlik Sense application, created a new NPrinting App and Connection, and attempted to reuse the same PowerPoint report template — but NPrinting prevents changing the connection during import.
Is this a normal limitation for PowerPoint reports in NPrinting?
And if so, is there any recommended workaround to reuse PowerPoint templates across different N Printing Apps/Connections?
Any insights or explanations would be greatly appreciated.
-
Rows disappear in stacked load containing Applymap()
Dear All,recently we experience issues connected to the ApplyMap() function.We have only recently updated our software to QlikvView May 2024 (yes we a... Show MoreDear All,
recently we experience issues connected to the ApplyMap() function.
We have only recently updated our software to QlikvView May 2024 (yes we are late...).
This issue only seems to occur when working with large datasets.
We are using the ApplyMap function in many places in multiple apps and it has always worked as expected:
When no value from the mapping table can be mapped to the table, either the expression itself was returned, or the default_mapping, if defined.
But now it happens that when there is no value in the mapping table, the whole row of the table is lost.
We can work around that by including additional steps in the stacked load but we would need to change a lot of applications.
Has anybody experienced the same issue? Is there a quick, sort of central solution? Has this been identified a bug in the QV version?
Best,
Karin -
cannot read geoJson file from geoAnalyticConnector
regarding this article: https://community.qlik.com/t5/Official-Support-Articles/Useful-Qlik-GeoAnalytics-Server-settings/ta-p/1494714 i'm trying to ... Show Moreregarding this article: https://community.qlik.com/t5/Official-Support-Articles/Useful-Qlik-GeoAnalytics-Server-settings/ta-p/1494714
i'm trying to Grant permissions to read local files to the keys, i'm in the admin GUI and i cant see there Access Module > Multialiases, i can see under Access Module only: documentation/ logs/ keys/ groups.
what can i do instead?
thank you,
elisheva
my full issue:
i located my goejson file under "C:\Users\qv\GeoData\NGV.geojson"
i added in geoAnalytics server "databasesaccess" in the file "C:\ProgramData\Qlik GeoAnalytics Server\server3\modules\webmap5\config\WebMap5Module.xml", and restarted the server.
in the goeAnalyticsConnector i entered url = 'lib://C:/Usersqv/GeoData/NGV.geojson'
and still get - "invalid url"
can you please guide me how to handle this issue?
thank you so much!
-
mobile app development
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 ... Show MoreHello 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.
-
Storing Nprinting Reports on Azure Blob Storage Network location
Hello All,I want help to store Nprinting Reports on azure blob storage. I followed steps from below blog on Qlik community and Nprinting successfully ... Show MoreHello All,
I want help to store Nprinting Reports on azure blob storage. I followed steps from below blog on Qlik community and Nprinting successfully completes the task execution too but the excel report is not showing on blob location.
Reference: Solved: NPrinting 17 - Distributing reports to folders - Qlik Community - 1376896
Any help would be appreciated.
Regards,
Aditya
-
Error executing Nprinting task from cmd, Out of memory error
I have a scheduled report that runs periodically throughout the day using a .bat file. The task is currently scheduled to run every two hours. The .ba... Show MoreI have a scheduled report that runs periodically throughout the day using a .bat file.
The task is currently scheduled to run every two hours. The .bat file opens Nprinting and executes a task that triggers the entire process.
This functionality worked correctly for over a year, but a few weeks ago it started malfunctioning. When I connect to the server to troubleshoot the problem, I get an "Out of memory" message.
I already checked and the server has enough memory and it's a virtual server.
Please help with this problem, and thank you very much. -
Connection NPrinting and Qlik Sense in different domains
Dear experts,we already use NPrinting within a domain for the distribution of reports from QlikView and also Qlik Sense. My requirement is now to set ... Show MoreDear experts,
we already use NPrinting within a domain for the distribution of reports from QlikView and also Qlik Sense. My requirement is now to set up another Qlik Sense server, from which reports are also to be sent. In the long term, this server is intended to replace QlikView. Since we want/need to give our customers access to Qlik Sense, the new server is in a different domain (DMZ) for security reasons. During my research in the community and on the Qlik pages, I read that the NPrinting server and the source system are supposed to be in one domain. However, I have also read that it may be possible to operate the systems in different domains by using virtual proxy servers. Can anyone help me solve the problem?
Is it possible to link via a virtual proxy and if so, what would I have to know/set for this?
Thank you for your help.
best regards
-
Custom Formatting of Measure
I have a measure with below calculation. Based on Currency selection we are showing values and format as well. When JPY is selected the number should ... Show MoreI have a measure with below calculation. Based on Currency selection we are showing values and format as well. When JPY is selected the number should not show decimal places. It is working in Qlik but same property is not being passed to Pixel Perfect NPrinting.
Is there a way in conditional format rule where we can define same rule.
If Currency ='JPY' then '$#,##0', else '$#,##0.00'. As you can see in Image Subtotal should show whole number with comma separated because currency selected in filter is J'PY' and rows above should show numbers with 2 decimal places because base currency is USD
I am adding both the formulas.
1. Below is used for subtotal
if(GetSelectedCount([Currency])=0 or Currency='USD', num(Sum({<ReportingMonthEnd={'$(=$(vEndDate))'}>}CURR_FUND_TNA_USD),'$#,##0.00'),
if(Currency='EUR', num(Sum({<ReportingMonthEnd={'$(=$(vEndDate))'}>}CURR_FUND_TNA_EUR),'$#,##0.00'),
if(Currency='GBP', num(Sum({<ReportingMonthEnd={'$(=$(vEndDate))'}>}CURR_FUND_TNA_GBP),'$#,##0.00'),
if(Currency='JPY', num(Sum({<ReportingMonthEnd={'$(=$(vEndDate))'}>}CURR_FUND_TNA_JPY),'$#,##0'),
if(Currency='CNH', num(Sum({<ReportingMonthEnd={'$(=$(vEndDate))'}>}CURR_FUND_TNA_CNH),'$#,##0.00'),
if(Currency='CAD', num(Sum({<ReportingMonthEnd={'$(=$(vEndDate))'}>}CURR_FUND_TNA_CAD),'$#,##0.00'),
if(Currency='CHF', num(Sum({<ReportingMonthEnd={'$(=$(vEndDate))'}>}CURR_FUND_TNA_CHF),'$#,##0.00'),
if(Currency='AUD', num(Sum({<ReportingMonthEnd={'$(=$(vEndDate))'}>}CURR_FUND_TNA_AUD),'$#,##0.00')))))))))
2. Used in the table for 4 and 5 column
if( BASE_CURRENCY='JPY',
If(
Len(Only(OpenFlag)) > 0,
Only(OpenFlag),
Num(sum({<ReportingMonthEnd={'$(=$(vEndDate))'}>}PRIOR_NET_ASSETS_BASE),'#,##0')
),
if(
Len(Only(OpenFlag)) > 0,
Only(OpenFlag),
Num(sum({<ReportingMonthEnd={'$(=$(vEndDate))'}>}PRIOR_NET_ASSETS_BASE),'#,##0.00')
))We have Feb 2025 SR2 nprinting version.
-
Year Over Year Counts
Hi all!I am trying to build a chart that shows every client who has one or more bookings in the "Chosen" year. Subsequently, I'd like to show, from t... Show MoreHi all!
I am trying to build a chart that shows every client who has one or more bookings in the "Chosen" year. Subsequently, I'd like to show, from that set, if those clients were return guests... ie if they had bookings over the previous year and/or the one before that. So I want only the clients in the bottom chart.
However, I have tried Alternate States and Set Analysis to try and make this work, and every time I add in the previous years, it gives me any client who had a booking in either of these two years, regardless of whether they had one in the year that I am trying to focus on.
Can someone please point me towards the formula I'd use to keep the chart from including clients that didn't book in the chosen year?
Thank you!
-
realize the function УРЕЗСРЕДНЕЕ (TRIMMEAN)
I have an array of goods with the sales documents.need to realize the function УРЕЗСРЕДНЕЕ (TRIMMEAN) in a table!a function something like median and ... Show MoreI have an array of goods with the sales documents.
need to realize the function УРЕЗСРЕДНЕЕ (TRIMMEAN) in a table!
a function something like median and average, but selects data at a rate of.
Established Coefficient variables
example:
1
2
4
8
16
32
64
128
256
512
1024
2048
УРЕЗСРЕДНЕЕ (A1: A12; 0,1) = 341,25
УРЕЗСРЕДНЕЕ (A1: A12; 0,4) = 127,5
УРЕЗСРЕДНЕЕ (A1: A12; 0,6) = 84
TRIMMEAN (A1: A12; 0,1) = 341,25
TRIMMEAN (A1: A12; 0,4) = 127,5
TRIMMEAN (A1: A12; 0,6) = 84
-
how to build a Pareto chart
have column sales, profit, quantity, how to create a chart/form to get a Pareto output -
Probleme direkt bei der Installation
Hallo bei der Installation des Qliksense stößen wir auf Probleme:Eventuell könnt ihr das durch die Fehlermeldung schon erkennen.System WIndows Server ... Show MoreHallo bei der Installation des Qliksense stößen wir auf Probleme:
Eventuell könnt ihr das durch die Fehlermeldung schon erkennen.
System WIndows Server 2022
Postgress wird auf einem Linux server bereitgestellt
Das ganze wird Ausgeführt als Administrator:
Error:
[2174:2050][2025-11-21T11:18:11]i000: Navigation to bookmark Next was initiated.
[2174:24E8][2025-11-21T11:18:11]i000: Before impersonation: CLI\Administrator
[2174:24E8][2025-11-21T11:18:11]i000: After finished impersonation: CLI\Administrator
[2174:24E8][2025-11-21T11:18:11]i000: Unexpected error during configuration: System.NullReferenceException: Der Objektverweis wurde nicht auf eine Objektinstanz festgelegt.
bei Qlik.Burn.Common.Validators.FolderValidator.ImpersonatedValidator.ValidateFolder(String folder, Func`2 evaluationCallback)
bei Qlik.Burn.Common.Validators.FolderValidator.ImpersonatedValidator.ValidateSharedRootFolder(String folder)
bei Qlik.Burn.Common.Validators.FolderValidator.ValidateSharedPersistenceRootFolder(String folder, String userWithDomain, ImpersonatedValidator validator)
bei Qlik.Burn.Common.Validators.FolderValidator.ValidateSharedFolders(String userWithDomain, String userPassword, String sharedRootFolder, String staticContentRoot, String archivedLogsRoot, String appsRoot, ILogger logger)
bei Qlik.Burn.Common.Managers.ValidationManager.ValidateSharedFoldersPath(String userWithDomain, String userPassword, String sharedRootFolder, String staticContentRoot, String archivedLogsRoot, String appsRoot)
bei Qlik.Burn.WF.Activities.ValidationActivities.ValidateSharedPathsActivity.Execute(CodeActivityContext context)
bei System.Activities.CodeActivity.InternalExecute(ActivityInstance instance, ActivityExecutor executor, BookmarkManager bookmarkManager)
bei System.Activities.ActivityInstance.Execute(ActivityExecutor executor, BookmarkManager bookmarkManager)
bei System.Activities.Runtime.ActivityExecutor.ExecuteActivityWorkItem.ExecuteBody(ActivityExecutor executor, BookmarkManager bookmarkManager, Location resultLocation)
[2174:24E8][2025-11-21T11:18:11]i000: In Error workflow: started
[2174:24E8][2025-11-21T11:18:11]i000: GetStringPropertyActivity retrieved the value C:\Users\ADMINI~1.CLI\AppData\Local\Temp\Qlik_Sense_May_2025_20251121111137.log from property WixBundleLog
[2174:24E8][2025-11-21T11:18:11]i000: Trying to navigate to InstallFailureView
[2174:2050][2025-11-21T11:18:11]i000: The ViewModel Qlik.Burn.UI.Sense.ViewModels.InstallFailureViewModel was initialized. -
User Input List - Multiple Text Values as Selection
Hello,I know this question has been posted here before but my data is somewhat different than most. I am an engineer, not a developer. I have large da... Show MoreHello,
I know this question has been posted here before but my data is somewhat different than most. I am an engineer, not a developer. I have large data sets of technical (not sales) data dealing with information about vehicles (identified by their unique 17 digit alphanumeric VIN). VIN = Vehicle Identification Number, e.g. 1A2B3C4DE5F987654. Each VIN is unique but each VIN can have thousands of records in the data. I need a way for the user to input a list of VINs and pass those into the selection for the 'VIN' field. This is only one of several ways that VINs can be selected so I need to be able to do it without reload (preferably copy and paste out of an Excel sheet). From what I have read on other posts, this is not an easy task.
What I've tried so far (unsuccessfully):
- Pasting list from excel into a single line of a list box > using a button with concat() function to pass the list box variable (which a tab delimited list of VINs) into the selection for VIN
- From Is there a way to have an input field allow for multiple lines of text?
- List box to text box
- User must enter values line by line
- I don't believe this will allow me to pass the values into selection.
- Requires a variable for each line of input > not practical because I need to allow at least 75-100 VIN inputs
- List box to text box
Again, I am engineer doing a developer's job so I am not proficient with macros/VBA. Any help here would be GREATLY appreciated.
Thanks,
CB
-
Eml adn PDf files
I read with QV an dir. with files. In the dir i have two type of files EML (Emails and PDF files).I like to have the DateMOdified. With my script belo... Show MoreI read with QV an dir. with files. In the dir i have two type of files EML (Emails and PDF files).
I like to have the DateMOdified. With my script below i get only result of the PDF files.
Is it possible to read thje date modified fomr an EML file ?
SET FilePath='*.*';
sub DoDir (Dir)
for each File in filelist ('$(Dir)\$(FilePath)')
SET sFile = '$(File)';
NomFile:
First 1 LOAD
daTE(FileTime()) As FileDate,
FileName() As FileName,
MID(FileName(),1,8) As Order.Nummer
from [$(sFile)];
next File
//
end sub;
call DoDir ('C:\files');
-
Issue with Info-bubbles where background is white and isn't readable anymore
Dear community,I would like to know if any one get the same issue than us.Recently, we noticed that the info bubble when we're on a layer with the mou... Show MoreDear community,
I would like to know if any one get the same issue than us.
Recently, we noticed that the info bubble when we're on a layer with the mouse is not readable anymore. (See image below).
Just in case, we have three environments and all of them get the issue.
We don't use a local GeoAnalytics Server but Cloud and just in case, we updated with the last version our GeoAnalytics extensions and connectors.
Thank you in advance for your help.
Kind regards.
