topic Re: Way to pass in parameters to the data load query from Nprinting in Connectivity & Data Prep

Way to pass in parameters to the data load query from Nprinting

jessicaw2020 — Wed, 15 Dec 2021 18:09:02 GMT

Hello,

is there a way to pass parameters into the data load query from Nprinting.

simple example:

in Nprinting the user will be asked what month they would like to see info of.

this parameter would be passed into the data load editor and the query would only gather data of that specific month filtered in. data load query would look something like this:

LOAD

SQL Select X,Y,Z from table where month=Parameter_month ( parameter month being the parameter passed in from Nprinting)

this might be over simplified to the point where I could do this filter elsewhere but in real life example, this will have implications on speed of the load query. i.e. filtering out millions of records using this filter and need it to be in the data load query.

Re: Way to pass in parameters to the data load query from Nprinting

JustinDallas — Mon, 06 Apr 2020 18:49:57 GMT

An NPrinting filter won't suffice?

Re: Way to pass in parameters to the data load query from Nprinting

jessicaw2020 — Mon, 06 Apr 2020 20:41:02 GMT

the problem is it needs to be filtered out while loading the data.

Re: Way to pass in parameters to the data load query from Nprinting

BalaBhaskar_Qlik — Mon, 13 Apr 2020 08:35:24 GMT

Try this:

https://help.qlik.com/en-US/nprinting/February2020/Content/NPrinting/ReportsDevelopment/Static-dynamic-filters.htm