Nprinting - Filters vs Current Selections

[Anonymous]

I have a list of 1000 recipients that I have imported into NPrinting  along with the 4 filters that I would like to use in order to generate the custom reports for each recipient.   I used Excel to create my list.

When I am working in my QV app, I have a very large dataset and I use the current selections boxes to "reduce" the data down so that only that applicable data shows up in my charts.  I am then  capturing images of these charts and sending them to NPrinting.  When I use the on-demand function, it works perfectly

What I try to mass produce my reports by running a task with my recipient list, it appears to only be trying to "filter" the data that gets exported to Nprinting, rather than using the filters as current selections to create the proper charts.  In addition, I use variables based on the current selections of one of my fields to create normative values in another chart.

My request is this:

How can an Nprinting task be configured to pass those filters as Current Selections  ( like it does with On-Demand )?

Or does anyone know how to use a variable to dynamically add fields to the Current Selection box?

Perhaps I can just pass a variable to Nprinting that would automatically populate the current selections box for each report.

[Anonymous]

Aran,

I have tried what you have explained above and without success.   It appears that this method is asking QV for the value to use as a field filter based on calculation.  For example, I think this means if I choose vCurrentYear, I am using the year 2015 as calculated by my QV document and using it to filter the data.

vCurrentYear is not the value.  vCurrentYear is the variable filter name and I want to tell QV that vCurrentYear is 2014 or 2015 or whatever I want.

I want to supply Nprinting with the value for the variable and the values could be different for every recipient.  When I manually create variables with values I supply, then I can run a task just fine and get the results I want.   I just don't want to manually type in 1000 of them.

I believe that we need a direct conversation to resolve this.  Can you please have Frank contact me and arrange for a WebEx.   I am sure that he has my e-mail address available from past conversations.

[#3]

Mike,

With my method you can assign existing filters to recipients you import with NPrinting.

With my method you can't build new filters or alter existing filters of any kind including those based on variables.

If you're trying to load recipients and build and assign variable based filters, that can't be done using NPrinting.

Best

Aran

[#4]

When a filter is being applied, it mimics making selection criteria in the applciation - if you have a large report that has filters, when you run it from designer, switch over to the QV applciation and you can see selections being made based on your filters.  You can also create filterin nprinting for the year field and make it dynamic so you do not have to chnage it all of the time

the attached article shows how to make a static and dynamic filter,  I have used this several times at the report and task level.

I agree with Aran as I am not sure why using nprinting filters will not meet your needs.

is there a small qvw and nsq you can provide to better explain and show the issue or concern?

[Anonymous]

Hi Adam,

Thanks for replying.  I am not experiencing Nprinting filtering like you are.   If you have read this whole thread, you know that I am trying to use Nprinting to tell Qlikview to make selections of 4 fields so that it will reduce my data in my charts.  I am exporting images, so it is mandatory that the charts are reduced to the desired data before sent to Nprinting.  

Here is what I am doing to make it work.  I create a filter and identify a VARIABLE not a FIELD.   In the VARIABLE filter, I put my variable name from Qlikview and the value that I want to send over.  I actually have 4 variables that I want to use for the task I want to run.   When I execute the task in Nprinting it sends my variables to Qlikview.  I have a trigger setup in the document properties, that senses a change to my variable and then triggers 4 select action statements.  These select statement assign my 4 variables to the fields that I want selected thus reducing my data.  When the Nprinting report finished collecting my data, the variables are reset back to the default state of zero.  When the next task runs it does the same thing.  Thus I can batch run 100 or more tasks ( each task gathers one report based on the variables ) and have the variables only get me the data ( images) sent back that I want.

I had to painfully key in 180 filters in Nprinting and add the variables that I wanted to add, because the import recipient function will only let you import FIELD filters and not VARIABLE filters

If you do not use variables and try to use field filters, then Nprinting collects your entire data set from your Qlikview app and then does the filtering when rendering.  That will not work for my project,

Also, when I setup my report with variables and push them, I can get my reports to render in 30 seconds or less.  That is 3-4 times faster than I can render them if I am using On-Demand from an Access Point

So, if Qlik would enable me to import data to a filter or directly to a task rather than a recipient or let me import and save to the variable fields, then I would have a lot more available to do production rather than data entry

This is actually pretty slick and I am guessing that not many know about it, as I have seen no documentation telling me how to do this.  I figured it out by necessity.

Let me know if you have any questions,

Mike

[#6]

quite impressive.  I did read the entire thread but did not completely understand, but your recent explantaion clears it up

yes, having the ability to import filters and fields (currently exists), variables or bookmars would be quite beneficial.

I did find something on the Qlik/NPrinting site that said this functionality was completed and was going to be in realese 15.6 - I wonder if it fell though after Qlik bout NPrinting

below is the link

Possibility to Import Variable Filters from File – Customer Feedback for Vizubi

[Anonymous]

I am on Version 16.0.0  so it they made this functional, I sure would love to have the process for getting it done as I have another 1000 filters to create and It takes me about a minute per filter to make.  I am a much better developer than I am a data entry clerk.   Aran, what happened with this?   Did this import function make it to production?  If you need a beta tester, I am ready to help!

[#8]

version 16 was just a rebranding after Qlik bought NPrinting so I am wondering if 15.6 was Nprinting's next scheduled release before the purchase.

1000 minutes /60 minutes in an hour = 16.7 hours or 2 work days

Now that is a use case

good luck

[Daniel_Jenkins · Accepted solution]

Hi Mike,

You can import variable based filters using the syntax :

[Connection].v\[VariableName]={[Value]<calculate>}

Where:

[Connection] is the name of the connection to the .qvw that contains the variable. This is optional.

[VariableName] is the name of the QlikView variable

[Value] is the value you want to set the variable to

<calculate>  flags the “Calculate” check box in the created filter. To be used when [Value] is a formula.

I have attached a sample project that imports and creates 2 recipients and 2 variable based filters, one with <calculate>.

Extract to folder C:\Temp\community\010 to preserve the paths used or change them in the nsq.

HTH - Daniel.

[Anonymous]

With all due respect to Mr. Nathanson, I am amazed that no one from Qlik has mentioned this option and directed me to this answer in the last week.  When I try to open your NSQ file, it gives me this error message.

So, I am using version 16.0.0.0  which I am assuming is the latest release.   So, what version are you using and did you get it before Qlik bought NPrinting?

[Anonymous]

Daniel,

You are a stud!   You have solved my problem.  I was able to import all 1193 of my filters in 15 seconds.  I will be creating a document to upload to the resource section describing how to do this and the other fun aspects of my project.  Here is the quick fix for anyone trying to import variables from Excel.  You have to put v\ in front of your variable name and include = between the variable and the value

The net result is that you can run a task in Nprinting  that will send your variables to QV.  If you use a document trigger to monitor variable changes, then the variables can become your selections and thus reduce the data sent to your report.  I just ran a job with 180 tasks ( individual reports with different variables ) and it took 100 minutes to run.  That is about 35 seconds per report.  When I was executing them On-Demand from Access Point it was taking almost 2 minutes per report.

As Daniel pointed out, this was fixed in release 15.6.  Strangely, this process is not  mentioned in the Nprinting Filter and Import Recipients documentation.

Aran, I will be in Orlando in May 2016 and you owe me a cold beer or two!