Import variable as recipient filter with excel

[miredoju]

Hi,

I know how to Import recipients via Excel - thats works as designed.

But how can I include a recipient filter as variable (not as field) ?

I think there must be a special syntax used in excel -  if I do it in the same way as I import recipient filter fields the variable would be imported as field.

Michael

[Daniel_Jenkins · Accepted solution]

Hi Michael,

In NPrinting 16.x 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.

Take a look at this thread if you want to download and test a working example: Nprinting - Filters vs Current Selections

NPrinting 17.x does not (yet) support variable type filters.

HTH - Daniel.

[miredoju]

Hi Daniel,

thanks so much - I don't know why I didn`t find this thread you send to me (I searched a lot ;-()

But now it works !

Michael

[khaled_dabbous]

Hi Daniel,

Does NPrinting 18.9.5 support variable type filters?

Khaled

[Daniel_Jenkins]

Hi Khaled,

Not yet supported in 17.x/18.x unfortunately. I have no news on when/if it will be supported.

HTH - Daniel.

[Hatus]

Hi Daniel

Since the new NPrinting November 2019 supports  variables as recipient filter I tried to import them in Excel like described and it seems not to work. All variables were imported as Fields.

Was the import variable as recipient filter with excel tested for the November 2019?

Best regards

Hatus

[Ruggero_Piccoli]

Hi,

Please avoid to continue a so old conversation, specially when it is already solved. Pleas open a new question, that will be more useful for other readers.

To import filters with variables from Excel files you need to add the  new column Variables as latest one of the Filters worksheet as visible in the attached file. Then you need to add the variables under that column. The syntax is:

- [VariableName]={FixedValue} in case you want to set a variable to a fixed value

-[VariableName]={"=Formula()"}<evaluate> in case you want to use a formula to calculate the value of a variable. Note the evaluate at the end.

You can add how many entries you want, you need only to separate each one with a comma.

Other parts of the same row still remain as usual.

Best Regards,

Ruggero

[Lech_Miszkiewicz]

Hi @Ruggero_Piccoli 

There is actually a bug in current help site as Examples.zip pack does not contain "Variables" column in recipient import template.

https://help.qlik.com/en-US/nprinting/June2019/Content/NPrinting/Examples/Examples.htm

[Ruggero_Piccoli]

@Lech_Miszkiewicz ,

Yes, I know and I notify it yesterday to the documentation team with a new Examples.zip file.

Best Regards,

Ruggero