topic Re: Set variable in Qlik NPrinting

Set variable

Chanty4u — Thu, 04 May 2017 07:48:48 GMT

Hi all,

Avinash R

Andy Weir

i want to set an variable in Qlik Nprinting 17.2.3

like FiscYear=Max(FiscalYear)

so how can i put variable as a filter?

can anyone give some idea on this?

Thanks

Re: Set variable

avinashelite — Thu, 04 May 2017 07:54:13 GMT

Same as you do in the Qlikview ..check this

How to Set a QlikView Variable to a Specific Value Using Filters‌

you can directly set the variable in Qlikview use the same as a filter in the NPrinting

Re: Set variable

Lech_Miszkiewicz — Thu, 04 May 2017 07:59:37 GMT

NPrinting 17X does not support variable filters! Cheers

Lech

Qlik NPrinting main features

This table compares the main features of Qlik NPrinting 17 with Qlik NPrinting 16. Features that are not currently available will be available in future releases.

Product Capability	Qlik NPrinting 16	Qlik NPrinting 17
Microsoft Office reporting	Yes	Yes
Pixel perfect and web reporting	Yes	Yes
Centralized distribution	Yes	Yes
On-demand reporting	Yes	Yes
Web based architecture		Yes
Online subscription hub		Yes
Multi-QVW Reports	Yes	Yes
Enterprise scalability		Yes
Roles based security		Yes
Multi-developer environment		Yes
Recipient imports from Excel	Yes	Yes
Conditional Reporting	Yes	Yes
Recipient Import Wizard	Yes
Dynamic Report Naming	Yes	Yes
FTP Support	Yes
Cycling Reports (creates files for every value of dimensions)	Yes
HTML embedded reports	Yes
Cycled pages in multiple slides	Yes	Yes
Variable filter	Yes
Bookmark filter	Yes
Object filters	Yes	Only with QlikView objects
Linked Fields	Yes
Load template	Yes	Yes

Re: Set variable

Chanty4u — Thu, 04 May 2017 08:13:27 GMT

thanks lech.

but how can i overcome this? is there any work around?

Re: Set variable

avinashelite — Thu, 04 May 2017 08:16:07 GMT

Add that as direct filter on the column with the set analysis or aggr function it should work

Re: Set variable

Lech_Miszkiewicz — Fri, 05 May 2017 01:46:36 GMT

Just like Avinash said do it in QlikView...

or ....

depending what you would like to use this variable for?

If it is kind of toggle where you want to switch dynamically variable value i would create a data-island field with all variable values it needs to have and then change a variable calculation to read from this field.

If this is a case where you always want to select max Year, regardless of any other selections - then maybe expression like this in variable would be handy:

=Max({1} FiscalYear)

For different use case we could build different scenario and solution.

cheers

Lech