Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to use the import wizard to upload one recipient ,
in my report i am using 3 different qlikview documents with in each Customername,as a filter field
I want in my import wizard to add to this one recipient filter Customername=X for connection 1 and filter Customername=X for connection 2 and filter Customername= X for connection 3.
It works when i do it manualy but i rather have it in an automated proces.
I can't imagine this is not facilitated, I just need to know how to do this.
Not using a connection results ( although filterfieldname and content are all over the same) that the filter is only applied on the first connection.
Many thanks!
Linda Monincx
Linda,
There's a tutorial which outlines the syntax you need to use here:
Advanced Filters Syntax on Recipients Import
The syntax is here:
[connectionName].[field] = {value1<isnumeric,evaluate>,value2<isnumeric,evaluate>,...}<drop,unlock,lock,verify,excluded>
You could also use a linked field to build the filter:
How to Create Linked Field Based Filters During Recipients Import
not sure I understand
correct me if I am wrong - you hae 1 customer that you send 3 reports to but based on the connection the filter for the customer is different
How are you setting up the customer and filter manually
Is there a reson you need to have the recipient load done automatically once the 1 customer is set up or does this need to be done for multiple customers in the long term
Linda,
There's a tutorial which outlines the syntax you need to use here:
Advanced Filters Syntax on Recipients Import
The syntax is here:
[connectionName].[field] = {value1<isnumeric,evaluate>,value2<isnumeric,evaluate>,...}<drop,unlock,lock,verify,excluded>
You could also use a linked field to build the filter:
How to Create Linked Field Based Filters During Recipients Import
knowing what you did manually will determine how to import the recipient and which specific syntax to use (per Aran's response)