Find the forums for your Qlik data analytics products to ask a question, start a discussion, or review documentation.
Find the forums for your Qlik Data Integration products to ask a question, start a discussion, or review documentation.
This forum will provide you with event highlights and related content to get you energized and ready for QlikWorld Online.
Here you will find Qlik Sense resources, partake in interesting discussions, solve problems and foster relationships with Qlik experts from around the globe.
Thank you for joining us in the QlikView Forum, your home for QlikView answers. Discover insights within your data that can transform your business.
Participate in Qlik Technical Previews, submit ideas, and review documentation.
Learn about upcoming Qlik related events, webinars and local meetups.
Join one of our Qlik Community Groups. Anyone can view content in Open Groups, but you must join to participate. Closed Groups require joining in order to view content and participate.
Hear directly from Qlik employees in our ten unique blogs. Check out the new Product Insight & Ideas Blog!
Qlik partners with leading technology companies to develop integrations, extensions, and connectors to the Qlik platform.
Discussion Boards and Documents for Qlik Services.
Learn about the Qlik Community. Explore 'How-To' documentation, ask questions, and engage in discussion around the community platform. This will also be the place where, from time to time, we will do some fun things.
Direct links to other resources within the Qlik ecosystem. We suggest you bookmark this page.
I am using a stacked bar chart with one dimension being a number format (stack), while the other dimension is character (bar). I'd like to sort this chart by the number dimension(bottom 5) in ascending order using that dimension. However by default, Qlik is using the measure to sort my stacked dimension. This default sorting by the measure is not my preference for displaying the information of interest.
I'm using following expression to get my accumulation values. but if I get any null values in the dimension then my accumulation sum is giving wrong result. Can some one help me on this?
=Range Sum(Above(TOTAL sum(SYSTEMS),0, Row No(TOTAL)))
I recently updated Qliksense to Feb 2020 Patch 1 and NPrinting to Feb 2020 SR1. I redistributed the certificates and all is working well (Nprinting talking to sense all fine)
The only issue I have now is with a script I use in sense that uses rest connectors to publish tasks on NPrinting.
When testing the Rest Connectors they work fine. it seems the vCookie varible ends up blank and all subsequent calls fail with a 403 error.
After the below script runs the vCookie variable ends up empty although the vCookieRaw varible contains a bunch of text.
I'm guessing something has changed in the new versions and I am no longer able to get the Cookie data? Can anybody assist?
LIB CONNECT TO $(vAPIConnectionNameForGET);
let vEndpoint= vNPrintingServer & '/api/v1/login/ntlm' ;
FROM (wrap on) "root" FK "__FK_root")
FROM JSON "_response_header" PK "__KEY__response_header"
with Connection (URL "$(vEndpoint)");
[Set-Cookie] AS [Set-Cookie]
WHERE NOT IsNull([__KEY__response_header]);
//Set Cookie header
let vCookieRaw = peek( 'Set-Cookie',0,'_response_header');
if vSSL='No' then
let vCookie = TextBetween('$(vCookieRaw)','Secure;','Path=/',2);
//Remove login tables
DROP TABLES RestConnectorMasterTable,[_response_header];
I have been battling the whole day with Nprinting.
I have tried to send myself a Powerpoint report via the task but it is not working.
The status keeps on "running" for hours.
I tried putting on filters but still cant generate the Powerpoint report. What could be the problem?
I have a report with many graph. In this report, I created a table with many columns, they come from my database.
In this table I have a column "Service" with many values "Informatic" "Finances" "Education" "Travel" ...
Actually, every day, I choose a service in this table (for example "Informatic"), I export the results of the table and send it by email to the responsable of the informatic service.
I do the same for each service (I send the results to the responsable of each service).
Unfortunately, I have 50 services so it's very very long.
It's possible to do the same thing automatically ?
I have Qlik Sense Enterprise
Thanks you very much.
I have this issue that I have tried to resolve myself for a week or two where the values of my straight tables are rendering in reports under the 'General' format instead of what I have chosen. I have posted some screenshots to help explain:
1. The qvw with the correct number format (some other tables will need to be a % or have different decimals). I have tried formatting in the expression itself as a workaround but it did not work. I can't select 'Keep source formatting' for this project.
2. The structure of the Template. You can see the cell is formatted to number. The table will expand across 5 cells and each is formatted to replicate how it is seen in the qvw. Each row will be a different table.
3. The result. It has ignored the formatting of the expression and the template editor and reverted to 'General'.
I have browsed before posting this question but I could not see a resolution, there were some considered solved but it was for QlikSense, and one post assumed that this problem would be fixed in a newer version of NPrinting (I started this project in NP 16.7 and continued it in the Feb 2020 version).
It might not mean much but I did a direct export from the table in the qvw to an excel file just in case the server settings was overruling it and it was matching the qvw.
I am trying to set up a basic Nprint report which shows all invoices generated per customer... in order to do this I have added a Level into the report.
When the report runs, it includes ALL customers even those that have no sales / invoices.
The source table in Qlik Sense is set to ignore null values, so only those customers with sales / invoices are displayed. How do I replicate this in the NPrinting report, so that customers with no sales / invoices are ignored? I cannot find any Nprinting options to enable me to do this.
Can any one help me on variable expansion in NPrinting.
I have passed the variables from csv file into qliksense app. There is no equal sign on variable definition in CSV file.
In Qliksense apps we have used these variables like =$(vTSCandidatesCount) but in N printing its not Working.
could you please explain with this example how to call it in N Printing from variable expansion.
Thanks in advance
For Fiscal Month i have values from Apr to Mar. I need a extra value 'ABC' added to fiscal month. From the transaction table, the master calendar is generated. How to do this?
Join the Qlik Insight Bot Group and bring the power and simplicity of natural-language, conversational analytics to everyone in your organization
Join the QlikView to Qlik Sense group and help you modernize your BI experience through adoption of Qlik Sense.
This group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights.
Boosting the data skills of your entire workforce can exponentially increase your data’s value. In this webinar, discover the big opportunity in data literacy.
Join us on for a deep-dive discussion and tailored product demonstration on the newest capabilities delivered as part of Qlik’s most recent product release.