Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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:
Hope this helps.
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
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
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.
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
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.