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.

Thanks

Hi,

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)))

Hi All

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' ;

RestConnectorMasterTable:
SQL SELECT
"Content-Length",
"Cache-Control",
"Content-Type",
"Date",
"Set-Cookie",
"Server",
"__KEY__response_header",
(SELECT
"result",
"code",
"message",
"__FK_root"
FROM (wrap on) "root" FK "__FK_root")
FROM JSON "_response_header" PK "__KEY__response_header"
with Connection (URL "$(vEndpoint)");

[_response_header]:
LOAD
[Set-Cookie] AS [Set-Cookie]
RESIDENT RestConnectorMasterTable
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)','HttpOnly,','Path=/',1);
else
let vCookie = TextBetween('$(vCookieRaw)','Secure;','Path=/',2);
end if

//Remove login tables
DROP TABLES RestConnectorMasterTable,[_response_header];
//exit script;

Hi,

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?

Hi all,

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.

Hi guys,

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.

Morning,

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.

Thanks

Craig

Hi ,

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.

Preview: 

Thanks in advance

Hi All,

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?