Hi all,

I have Nprinting 16.0 and a want upgrade to 16.7 oder 16.9 to export my Project.

where can I fand the Installation Files?

On a new Server I installed NPrinting February 2014 SR2 and I have do move my Projects from my old NPrinting.

I want to create an automation that iterates over Excel files in a folder on Sharepoint. For each file found the Excel file should be opened and a Worksheet (always the same name) should be read. I can list all Excel files in the folder (List Files on Microsoft Sharepoint with a path, but Excel's List Rows from Worksheet requires a File ID. I can find the FIle ID manually by lookup, but how do I find it automatically from all files in the folder?

I have a worksheet with multiple tables.

example:

The tables on the bottom have to be filtered by the filter 'team'.

the table on the top has to be filtered on a hard value, independent of what is selected in the filter in the blue square.

I created a filter for the upper table with the expression:

if(Team='Staf', Groep,)

which worked.

But then I created the lower 2 tables which do have to be filtered by the selected value in the blue square (only 1 selected possible). However, this changes the table on the top also.

I then thought: I create an alternate state for the table on the top so the selection in 'Team' doesn't affect this table, but I ended up with 'Team' being in the selection bar, showing 'selection in 2 states'.

I do not want selections in 2 states. I only want selections in 1 state.

How can I achieve this? Is it possible to have the top table filtered on a hard coded value and not being affected by any selection made in this variable AND the variable not having 'selections in 2 states' in the active selections bar? I want to be able to quickly change the selection of 'team' as I expect the user not to understand for which state the selection has to be changed.

Hi 
I trying to load data from xlsx files that are sitting in a SharePoint directory, but getting an error during the load
I am using 

for each file in filelist('lib://test_Space:Office_365_Sharepoint - Qlik/Shared Documents/testReports/*.xlsx')
    LOAD 
    wh_id,
    EXPORT_DATE,
    client_code
  FROM [$(file)] (ooxml, embedded labels);
next file

but I am getting an error  

The following error occurred:
Connector error: Failed on attempt 1 to GET. (-2147024894, System.IO.FileNotFoundException, File Not Found.)
The error occurred here:
for each file in filelist('lib://eGold_Space:Office_365_Sharepoint - Qlik/Shared Documents/eGoldReports/*.xlsx')

I'm only getting the error when trying to load wildcard (*.xlsx) but if I am using a full name of one of the files in the directory it works 

Thanks in advance

Hi,

I have a table created with one dimension and 6 measures created  which has 45 rows of data

Created nprintinng report by adding that object as table in nprintinng excel report template.now my requirement is to calculate the average for all the 45 rows of data .I tried creating formulas but it's giving some what wrong value as I have null value in one row out of 45 rows of data.

Regards,

Hi,

we are using a condition in NPrinting to avoid sending out reports where the app reload failed or didn't start at all due to previous reload tasks fail.

The variable is defined as follows in Qlik Sense: LET vReloadDate = Date(Today());

In NPrinting the condition is defined as follows:

Last weekend the app in Qlik Sense wasn't reloaded (both Saturday and Sunday) since a previous process step failed. However NPrinting still send the report on Saturday and Sunday. So I was asking myself if NPrinting keeps the result of a condition in the cache as long as the app isn't reloaded.

Is there anyone who had a similar issue?

Today we updated to NPrinting February 2024, not sure if there was a fix regarding that topic between the two versions.

Qlik NPrinting 

I have an app with a button that calls a partial reload.

If two users press this button at the same time, what happens? Currently, what I'm seeing is that one user gets the correct details back, but the other does not get new data. But I'm not totally sure why this happens. Is it because the dashboard simply didn't reload (as it was already in progress for the first user) or could it be something else? 

It's really hard to debug anything to do with partial loads, but more so when you're looking at concurrency.

I found a script to create a master calendar (https://community.qlik.com/t5/QlikView-App-Dev/How-to-Create-Master-Calendar/td-p/103109)

In the first table I loaded these variables:

Appél:
LOAD
    //Peloton as %Pel_nr,
    "V-nummer" as [%P_ID-nr],
    Year(datum)&num(month(datum))&Day(datum) as %Cal_SL_appel,
    datum as appel_datum,
    opmerkingen as appel_opm,
    bijzonderheden as appel_bijz

later on, I have this part of the load script:
Load

Date($(vMinDate) + IterNo() - 1) as <DateField>
AutoGenerate 1
While $(vMinDate)+IterNo()-1 <= $(vMaxDate);

I want it to be like this field:

    Year(datum)&num(month(datum))&Day(datum) as %Cal_SL_appel,

But I don't see how I can get it in the master calendar like this.

When I make it like this:

Load

Year(Date($(vMinDate) + IterNo() - 1))&Num(Month(Date($(vMinDate) + IterNo() - 1))&Day(Date($(vMinDate) + IterNo() - 1))  as %Cal_SL_appel

Autogenerate 1

While $(vMinDate)+IterNo()-1 <= $(vMaxDate);

I get an error: appel_datum not found

I don't see how I can get the datum in the desired format in my master calendar and make it the unique key used to connect to the table 'Appél'.