topic Re: filter in Nprinting in Qlik NPrinting

filter in Nprinting

nareshthavidishetty — Wed, 25 Sep 2019 18:40:54 GMT

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

Re: filter in Nprinting

avinashelite — Tue, 29 Mar 2016 06:47:50 GMT

You could create a filter for the same , write the expression in the Qlikview and apply the same in the Npriting

check this

How to Create Static and Dynamic Filters Based on Fields

Filtering in nPrinting for a Qlikview report | Qlik Community

Re: filter in Nprinting

nareshthavidishetty — Tue, 29 Mar 2016 06:59:34 GMT

thanks for the reply Avinash i have gone through the document but my requirement is i need all the date ranges

like if user want to see last 2 weeks wise data,or last 3 months wise data or, last 10 days data etc

plz tell me how i do that requirement

any sample example would be helpfull

Re: filter in Nprinting

avinashelite — Tue, 29 Mar 2016 07:08:50 GMT

you Could try like this

1.Capture the user requirement in variable i.e. like 1month or 10 days etc

2. Use this variable in the Nprirting to set the data range (write a expression in the Qlikview to get the date range )

3. Based on the expression the date range will get set automatically according to the user requirement

*Currently I don't have the QV

Re: filter in Nprinting

nareshthavidishetty — Tue, 29 Mar 2016 11:31:34 GMT

if i create variable like what u said then i will end up with more variables like for week range 1 variable ,for 10 days 1 variable or 15 days range 2 variables so on....

i'm bit confused any suggestions would be helpfull

thanks

Re: filter in Nprinting

avinashelite — Tue, 29 Mar 2016 11:41:50 GMT

No , create one variable but create multiple buttons or text objects so based on the click of button/text add the action to set the same variable so that it will be always on variable at the backend , based on the use selection the variable will get set

Re: filter in Nprinting

nareshthavidishetty — Wed, 30 Mar 2016 06:27:05 GMT

Hi Avinash

thanks for the reply could you please tell me the steps so that i follow and create the variables

plz dont mind as i m new to this it is very helpful if you jus tell me how to do what u mentioned in the above like creating text and setting variables

thanks

Re: filter in Nprinting

nareshthavidishetty — Wed, 30 Mar 2016 06:39:50 GMT

anyone plz help me im still stuck and i need to finish this things waiting for ur valuable suggestions

thanks

Re: filter in Nprinting

avinashelite — Wed, 30 Mar 2016 06:57:23 GMT

Try like this

1.Create a variable (Ctrl+V) , vNumber_of_days

2. Add three text object like 2.1 10 days

2.2 15 days

3. Add action in each text box , Go to text box properties > Action > select external > Set variable

4. vNumber_of_days and in value add 10 or 15 etc based on the text object

once the use click on the object the variable will get set and you could use the same

if(Date_field>= Today()-vNumber_of_days and Date_field<= today(), Date_field)

only({<Date_field={">= Today()-vNumber_of_days <= today()"}>}Date_field)

Re: filter in Nprinting

nareshthavidishetty — Wed, 30 Mar 2016 07:12:45 GMT

thanks for the reply i vll try and let u know

Re: filter in Nprinting

Daniel_Jenkins — Wed, 30 Mar 2016 09:43:25 GMT

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.

Re: filter in Nprinting

manishnarang — Mon, 08 Aug 2016 12:17:03 GMT

Daniel, you are a live saver.

thanks.

Re: filter in Nprinting

AlipNath — Wed, 11 Apr 2018 14:24:09 GMT

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.

Re: filter in Nprinting

vikasmahajan — Sat, 20 Jul 2019 05:58:39 GMT

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

Vikas

Re: filter in Nprinting

Daniel_Jenkins — Mon, 22 Jul 2019 08:47:23 GMT

Hi @vikasmahajan,

You will need to be on NPrinting June 2019 at least.

https://community.qlik.com/t5/Qlik-NPrinting-Documents/Examples-of-Advanced-Search-Filters/ta-p/1594779

HTH - Daniel.

Re: filter in Nprinting

vikasmahajan — Mon, 22 Jul 2019 09:09:40 GMT

Re: filter in Nprinting

vikasmahajan — Sun, 18 Aug 2019 05:08:36 GMT

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.

Re: filter in Nprinting

Daniel_Jenkins — Sun, 18 Aug 2019 23:45:06 GMT

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.

Re: filter in Nprinting

vikasmahajan — Mon, 19 Aug 2019 04:22:15 GMT

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

Re: filter in Nprinting

Daniel_Jenkins — Mon, 26 Aug 2019 22:03:49 GMT

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.