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: 
Not applicable

qv variables as nprinting filters

Hi,

I have a list of sales people that I have stored in a variable vSalesReps as :

'TOMA','DICK','HARR' etc.

I want to use that variable as a filter for nPrinting reports (i.e. only select the people in vSalesReps).

I've tried a couple of different ways of using the 'variable' option when building a filter in nPrinting, but it doesn't

select anything (and returns all users, not just sales).

Anyone know how to do this?

thanks,

Kevin

6 Replies
Daniel_Jenkins
Specialist III
Specialist III

Hi Kevin,

Since you want to filter for more than one SalesRep, I would create a filter based on the SalesRep field rather than on a variable. Something like Fields: SalesReps {TOMA,DICK,HARR} assuming SalesReps is the field name. Here are some links to articles that explain filters in more detail:

http://community.vizubi.com/knowledgebase/articles/260269-how-to-create-static-and-dynamic-filters-b...

http://community.vizubi.com/knowledgebase/articles/413836-how-to-use-qlikview-advanced-search-with-n...

http://community.vizubi.com/knowledgebase/articles/363665-how-to-set-a-qlikview-variable-to-a-specif...

Hope this helps.

Not applicable
Author

Hi Daniel,

Thanks, but I need the report to be filtered to just a single rep. I use field based filters, as you suggest, all the time. But in this case, I want the report filtered to a single rep, and sent to a specific group of people, which is why I wanted to use a variable.

Thanks,

Kevin

avinashelite

Hi Kevin,

Try like this:

Import the variables from the qlikview, then got to conditions in NPrinting here select the variable and check with equal condition , check the calculate option.

otherwise in Qlikview a create a list box with this set of users and in NPrinting use cycle option and loop thorough this list box.

Hope this helps you

Anonymous
Not applicable
Author

Kevin,

Did you ever solve this problem?    I am trying to solve a similar problem and may have the answer you are looking for if this is something you are still working on.


Not applicable
Author

Hi Mike,

The requirements were changed, so it was no longer an issue. Looking back, I see that I didn't state the problem clearly. The issue was:

for sales rep "A", send the report to John and Fred

for sales rep "B", send the report to John, Fred, and Mary

for sales rep "C", send the report to John, Mary, and Tom

for sales rep "D", send the report to John and Fred

- etc - for 12 sales reps

Now, it's easy to do this by creating 12 separate tasks, but that's a pain to maintain. I was hoping to find a way to do this more elegantly. If you have an idea you'd like to share, I'm all ears!

thanks,

Kevin

Anonymous
Not applicable
Author

Hi Kevin,

I am still in the middle of the battle.   I have a similar situation to you and I want to be as efficient as possible.  I will follow up with you soon and share my results.