topic Re: Import variable as recipient filter with excel in Qlik NPrinting

Import variable as recipient filter with excel

miredoju — Sun, 04 Sep 2016 07:14:11 GMT

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

Re: Import variable as recipient filter with excel

Daniel_Jenkins — Sun, 04 Sep 2016 21:27:24 GMT

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.

Re: Import variable as recipient filter with excel

miredoju — Mon, 05 Sep 2016 12:51:35 GMT

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

Re: Import variable as recipient filter with excel

khaled_dabbous — Thu, 31 May 2018 12:38:17 GMT

Hi Daniel,

Does NPrinting 18.9.5 support variable type filters?

Khaled

Re: Import variable as recipient filter with excel

Daniel_Jenkins — Mon, 04 Jun 2018 04:12:19 GMT

Hi Khaled,

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

HTH - Daniel.

Re: Import variable as recipient filter with excel

Hatus — Mon, 18 Nov 2019 10:29:48 GMT

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

Re: Import variable as recipient filter with excel

Ruggero_Piccoli — Mon, 18 Nov 2019 12:03:27 GMT

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

Re: Import variable as recipient filter with excel

Lech_Miszkiewicz — Mon, 18 Nov 2019 21:42:36 GMT

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

Re: Import variable as recipient filter with excel

Ruggero_Piccoli — Tue, 19 Nov 2019 08:21:50 GMT

@Lech_Miszkiewicz ,

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

Best Regards,

Ruggero