All Forums

i see several blogs to call nprinting tasks using qliksnese load script via rest apis.

can we call OnDemand nprinting requests via qliksense load scripts too.. for applying some dynamic filters in nprinting..??

Hello
I'm calling an Nprinting task from Qlik sense using rest connector
I want to do a loop in order to check the status of the task (running, finished,...)
so this loop reads the status of the task until it is either Aborted, or Finished
so I want to know the possible values returned as task status so that I check in the loop if it not finished then keep looping

Hello All -

We are finally migrating from NPrinting 16 and I'm getting an error on a task:

How do I figure out the report and user from those ID #s?

Thanks!

Good morning.
I am looking for assistance with identifying item by Customer in a pricelist where some items are on 'promotion'.
Looking at the data you see that ItemCode PRODAAA is on promotion for CustomerCode CUSTAAAA and CUSTBBBB.
Their normal pricelist is PL1 and PL2 respectively, but currently they should see the Custom price for this Product.

tmp_Custom:
LOAD * INLINE [
Company, CustomerCode, ItemCode, "Price List", Price
TEST, CUSTAAAA, PRODAAA, Custom, 120
TEST, CUSTBBBB, PRODAAA, Custom, 130
];

tmp_Pricelist:
LOAD * INLINE [
Company, CustomerCode, ItemCode, "Price List", Price
TEST, CUSTAAAA, PRODAAA, PL1, 140
TEST, CUSTAAAA, PRODBBB, PL1, 150
TEST, CUSTAAAA, PRODCCC, PL1, 160
TEST, CUSTAAAA, PRODDDD, PL1, 170
TEST, CUSTAAAA, PRODEEE, PL1, 180
TEST, CUSTAAAA, PRODFFF, PL1, 190
TEST, CUSTBBBB, PRODAAA, PL2, 150
TEST, CUSTBBBB, PRODBBB, PL2, 160
TEST, CUSTBBBB, PRODCCC, PL2, 170
] ;

Using CUSTAAAA as an example, I would like to have a table that shows their normal PL1 ItemCode for other items BUT for PRODAAA it must only show the Custom price row, not the PL1 row.

When I see the finish result table it should look like below:
Company, CustomerCode, ItemCode, "Price List", Price
TEST, CUSTAAAA, PRODAAA, Custom, 120
TEST, CUSTAAAA, PRODBBB, PL1, 150
TEST, CUSTAAAA, PRODCCC, PL1, 160
TEST, CUSTAAAA, PRODDDD, PL1, 170
TEST, CUSTAAAA, PRODEEE, PL1, 180
TEST, CUSTAAAA, PRODFFF, PL1, 190
TEST, CUSTBBBB, PRODAAA, Custom, 130
TEST, CUSTBBBB, PRODBBB, PL2, 160
TEST, CUSTBBBB, PRODCCC, PL2, 170

For more info, these tables come from different sources. I am able to rename fields if need be.
I've tried creating keys with Company, CustomerCode, ItemCode, "Price List" and then using where not exist.

If you are able to provide some ideas, I really appreciate it.
Thank you in advance.

Hello
I got a publish task that was working fine yesterday
today I run it again and it is stuck on 0% and there is not log written when I click the link of the task in Admin->Task Execution

what should I look for?
would restarting the Nprinting server solve the issue?

below is the status after 3 hours of running

Hello,

I need to calculate the weeks of coverage (WoC) for each month in my table. The formula is : (inventory of the month) / ((sum of next 3 months)/13).

I have a pivot table like this:

Feb WoC = (1000 / ((200+300+200)/13) = 18.6

Mar WoC = (1500 / ((300+200+300)/13) = 24.4

etc.

in my table, i use dimensions Month (text based) (Jan, Feb, Mar etc.). (I have another dimension for month in numeric: Month.nb (1,2,3,etc.) which is not in the dimensions of my table, it's a helper)

What should be the correct set expression to get what i need ?

For the moment, as a practice, I tried to simply get the sum of sales of the next 3 months, but it does not work. For each month (jan, feb, mar), I get the sales of that same month with the below expression:

Sum({$<[Year]={$(=Only([Year]))}, [Month.nb]={1,2,3}>}[WF SALES C US$])

(with above, i expected to get for each Month (jan to dec) the sum of sales of Month 1+2+3. But I get sales of month 1 for Jan, sales of month 2 for Feb, sales of Month 3 for March and no sales for the other months)

The selection is only the year and the region. There is no other selection related to the period or time.

Thank you

Hi folks,

Had a strange one come up today. 

A Pie chart we have in QV, it's data is auurate, but the segments are not proportionate to the data itself.

In the below, the Teal segment is 50% of the Crimson segment in value, but definitely not 50% of it's size.

Then the light blue ((1,274) is smaller than the Teal (777).

Hi All,

I recently got a requirement to uninstall old softwares ( VC ++ 2010). We had nprinting May 2022. Now we installed nPrinting Feb2025 everything worked fine until we uninstall the old VC ++ even though we have VC++ 2015-2022 installed. All services are running fine, it just gets stuck when generating a report. How do I fix this?

BR,

Qlik NPrinting 

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  

Hi,

I try to build a datamodel with generic keys and I wanted to use Autonumber as an ID Field for a dimension table but it starts counting from 3.

I use the following code:

ACTION:

LOAD Distinct

Action,

Autonumber(Action) AS %ActionID

RESIDENT CLEANUP;

Another table even starts counting from 127.

Has it something to do with empty fields? I had a "WHERE len(Action)>0;" but the result was the same.

Someone who has an explanation?

Regards,

Peter