Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
nareshthavidishetty
Creator III
Creator III

filter in Nprinting

hi all

im new to Nprinting i got stuck could anyone help me plz

my requirement is i want to generate a report month wise which i had accomplished but if i want 15 days back or 20 days back how can i do in Nprinting

date field is (Date_trans)

Daniel can you help me,

help me out some one

20 Replies
Daniel_Jenkins
Specialist III
Specialist III

Hi Naresh,

If you have variables in your QlikView document that store the dates for the range required you can use a filter in QlikView NPrinting to restrict output to records that fall within that date range.

Lets say you have variables vStartDate & vEndDate like this:

You can see that records in the unfiltered chart have DateTrans values that fall within and also out of this date range:

You can use a Field filter like this on the report:

To get filtered Excel output like this:

Project attached. Extract to folder C:\Temp\Community\058 or change the paths in the NSQ.

HTH - Daniel.

manishnarang
Partner - Creator
Partner - Creator

Daniel, you are a live saver.

thanks.

Olip
Creator
Creator

How do we implement the same in Qlik Sense for Nprint. I need to filter a range of data and not getting much information about it.

- Eager to learn n grow,

Olip
vikasmahajan

Is same possible using Qlik sense ?  I am using Feb19 QS & Nprint 18 

 

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
Daniel_Jenkins
Specialist III
Specialist III

vikasmahajan

 
Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
vikasmahajan

Hi Daniel,

I have installed Nprint June 2019 version along with QS june as well tested your approach unfortunately It is not

working. I require vStartdate & vEnddate as a filter for on demand extension. After selecting range should pass to Nprint report as per range given by user report should be published in newsstand.

 

Please help required on priority. since client is required on  top priority.

 

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
Daniel_Jenkins
Specialist III
Specialist III

Hi @vikasmahajan ,

The idea of On-demand is for users to make selections and generate reports that respect those selections. Reports are then directly available for download from the Qlik Sense hub or the Accesspoint (if using QlikView) - not in the NewsStand. You should not be using any other filters (advanced or otherwise) as user selections are your filters here. Perhaps you need to clarify your requirement in more detail and someone here can advise you of your options.

HTH - Daniel.

vikasmahajan

Hi

 

Thanks for your response

Just to let you know we are using qlik sense june 2019 and N printing june 2019

 

My requirement is that on demand feature will be used in application by power users at the same time i need provision to schedule the same report on newsstand so that it is available to larger audience which will be read only users. These users are branch level users who spread across multiple locations within the country. These users will just check the data quality and send it to centrsl bank regulatory authority. Hence i want same filtered dstavto be available on newsstand also. 

Regards

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
Daniel_Jenkins
Specialist III
Specialist III

Hi Vikas,

You will need to handle those two requirements separately. "On-demand", by definition, is for a user to make selections and download a predefined report appropriately filtered. You cannot use On-demand to publish to NewsStand.

HTH - Daniel.