Qlik Community

Ask a Question

Qlik Sense Data Connectivity

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor
Contributor

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

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 

X,

Y,

Z;

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. 

3 Replies
Specialist II
Specialist II

An NPrinting filter won't suffice? 

Contributor
Contributor

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