This video series is designed to introduce you the Qlik NPrinting PixelPerfect report editor.

You can download this tutorial version also in PDF. The PDF contains all the formulas that are used in these tutorials.

Introduction
1. Working with PixelPerfect reports - Introduction	2. Getting started creating PixelPerfect Reports
Working with formulas
3. Add a formula to show the report creation date	4. Using formulas to calculate revenues
PixelPerfect designing features
5. Adding a Qlik Sense chart as an image	6. Creating a native PixelPerfect chart
7. Creating a native PixelPerfect table
PixelPerfect advanced features
8. Using scripts in a PixelPerfect reports	9. Using conditional formatting in a PixelPerfect report
10. Adding a sparkline in a PixelPerfect report	11. Adding page info a QR code in the page footer of the report
12. Adding images inside a level of report	13. Adding a table of content in a PixePerfect report

When importing Qlik NPrinting users from an Excel file, it is possible also to create filters that made selections on more than one field.

Be sure to know the content of https://help.qlik.com/en-US/nprinting/May2022/Content/NPrinting/DeployingQVNprinting/Import-Users-Filters.htm#anchor-2 before proceedeing.

This article is valid for all Qlik NPrinting versions that supports users import via Excel file.

The sample file is attached.

In the Filters worksheet of the source Excel file create a row like the following:

In the column Values there are selections based on two fields: [Country]={Austria, Belgium},[CategoryName]={Babywear, Sportswear}. As you can see you have to simply separate the selections on each field by a comma.

In the column Numeric values there is the selection [Year]={2019} that also will be part of the created filter.

Create an Import Task as usual and run it. The result will be a new filter like:

It includes all the selections based on different fields we inserted in the Excel file and:

they have the correct setting in the drop-down menu.

The NPrinting Audit Trail application is a Qlik Sense application that is intended to be run in Qlik Cloud, Qlik Sense Enterprise Client-Managed, or Qlik Sense Desktop. This application summarizes and profiles the audited report execution activity of one or more NPrinting sites.  It provides a view of the quantity of reports produced that is drillable by format, destination and other dimensions.

The application can help quantify dependencies prior to moving to Qlik Cloud and can also serve as a snapshot of raw reporting volume that exists on a production system.

Please see the attached configuration guide for setup instructions in your own Qlik Sense environment.

Note: If you only use NPrinting with QlikView, you can still use this application provided you have access to a Qlik Sense environment.

SHEETS:

Requirements

• NPrinting Audit Trail Enabled  

https://help.qlik.com/en-US/nprinting/May2022/Content/NPrinting/AdministeringQVNprinting/Audit-trail.htm

• NPrinting November 2020+
• Qlik Sense Client Managed August 2022+   or   Qlik Sense Desktop August 2022+   or   Qlik Cloud

Starting with 15.2, it's possible to import filters specifying the ConnectionName and isNumeric and Evaluate parameters. With 15.3.0.1, you can also import a field that seems numeric as text. This tutorial explains this new syntax.

Read "Filter Syntax, Parameters, and Options for Importing Recipients" prior.

NPrinting New Syntax Explanation

  

From NPrinting 15.2 and forward, you may use the following syntax:

[connectionName].[field] = {value1<isnumeric,evaluate>,value2<isnumeric,evaluate>,...}<drop,unlock,lock,verify,excluded>

• [connectionName] = name of the connection. By specifying this you can create different filters based on fields with the same names from different connections
• [field] = field name
• value1 = first value of the field to select. You can add as many values as you want
• <isnumeric,evaluate> = if one or both are specified, the correspondent flag will be activated
• <drop,unlock,lock,verify,excluded,clearselections> = filter options, the ones you add will be activated

The old syntax still works. If you use the old syntax you don't need to specify the name of the connection, isNumeric and Evaluate parameters.

    

Open the Excel Recipients Source File

            

                        

  

1. Go to C:\NPrintingTraining\Recipients
2. Double-click on RecipientsFiltersComplete.xlsx

Add a New Worksheet

            

                        

  

1. Click on the New Sheet icon.

    

Rename the Worksheet

            

                        

  

1. Rename it to isnumeric and evaluate import
2. Create a header row.

Create a New Filter

            

                        

  

1. Full Name: enter a persons name or other identifier
2. Filter1: enter Year={2013<isnumeric>,year(now())<isnumeric,evaluate>}<verify>

The other fields aren't mandatory.

If you don't specify the connection name, it will refer to the default connection. Entering this line of code, the Year field is set to two values:

• Numeric value set to 2013
• Formula "year(now())" set to isNumeric and Evaluate. This formula returns the numeric value of the current year. Evaluate is necessary to force the evaluation of the formula.

Verify filter option is activated.

Specify the Connection When Creating a New Filter

            

                        

  

1. Full Name: enter another persons name or other identifier
2. Filter1: enter [SalesDemo].[Year]={2013<isnumeric>,year(now())<isnumeric,evaluate>}<verify>

In the first part of this line of code the name of the connection of the Field is specified. By specifying this you can create different filters based on Fields from different connections.

Create Two New Filters Referring to Two Different Connections

            

                        

  

1. Full Name: enter another persons name, title or other identifier
2. Filter1: enter [SalesDemo].[Year]={2013<isnumeric>}<verify>, [Sales Compass].[Opp Close Year]={2013<isnumeric>}<verify>

In this case two Fields from two different connections are specified. With this new syntax it is possible to create filters based on fields from different connections.

   

Final Result

            

                        

  

After importing the Recipients, you'll find a new filter with two fields from two different connection.

Specify the Connection Name

  

Starting with 15.3, it's possible to explicitly set or unset a flag for the isNumeric and Evaluate parameters. Previous syntax will still work.

[connectionName].[field]={value1<isNumeric=yes,Evaluate=no>, value2<isNumeric=True,Evaluate=True>}

You can use "Yes" or "No" or the boolean values "True" or "False".

Explicit Set of isNumeric and Evaluate

            

                        

  

1. Full Name: enter another name or identifier
2. Filter1: enter Year={2013<IsNumeric=yes,Evaluate=no>, "Year(Now())"<IsNumeric=True,Evaluate=True>}

In the first part, the IsNumeric flag is explicitly set to Yes and Evaluate to No. In the second part the IsNumeric and Evaluate flags are both forced to True, which is synonymous with Yes. This means that the expression will be evaluated and return a numeric value.

Force a Value that Seems to be a Number to be Compared as a String

            

                        

  

1. Full Name: enter another persons name, title or other identifier
2. Filter1: enter CustomerIDText={0063<IsNumeric=no,Evaluate=no>}

The QlikView field CustomerIDText is created as a text field but it contains values that seem to be numbers. By inserting "IsNumeric=no" we are sure that the flag will be disabled and the value "0063" will be compared as a string.

Use double quotes (") to import filter values that contain commas

            

                        

  

1. Full Name: enter another persons name, title or other identifier
2. Filter1: enter Address={"2, rue du Commerce", "24, place Kléber"}

You can import filter values that contain commas (,) by enclosing them between double quotes ("). Using a comma outside will continue to be the separator between two value.

Use double quotes (") to import filter values that contain formulas with commas

         

1. Full Name: enter another name or identifier
2. Filter1: enter MonthNum = {"num(month(AddMonths(now(),-1)))"<isnumeric,evaluate>}

You can import filter values that contain formulas with commas (,) by inserting them between double quotes(").

Recipient import

            

                        

  

To import new Recipients refer to "How to Create and Import Recipients with Filters and Distribution Groups".

From NPrinting June 2019

• Introduction of a new filter type called Advanced search. Here are a few examples of how it can be used.

Note: I have made a few changes to a copy of the sample Qlik Sense App found here and used that as the Connection source for these examples. The modified App and exported report are attached to this post.  

Fields that exist in the source document that we use:

1. Date
2. Customer

Variables that exist in the source document that we use:

1. vStartDate
2. vEndDate

Example 1.

Filtering for a date range. 

With Advanced search filters you can filter for a date range in any of these ways:

• hard coding the From and To dates. Example: =Date <= Date#('06/22/2019', 'MM/DD/YYYY') and Date>=Date#('06/22/2018', 'MM/DD/YYYY')
• Using expressions. Example: =Date <= num(Today(1)) and Date >=num(Today() - 365)
• Using variables that exist in the source document. Example:  =Date>=$(vStartDate) and Date<=$(vEndDate)

Note: The above filters were defined on the Date field. You can also define the same filters for other fields just as you can use expression search in the source document if you want to search for values in associated fields. For example you could use the exact same filter definition for the Customer field to get different results:

Screenshots of the Filter editor showing the difference:

Example 2.

Filtering for the Top n 

Here is an example using Advanced search filters and Aggr() to filter for the Top 10 Customers (most Sales). You can of course use a variable or an expression that results in an integer instead of hard-coding the number 10.

=Customer=aggr(if(rank(sum(Sales)) <=10, Customer), Customer)

Example 3.

Filtering for a range

Similar to example 1. Here again you can use variables or expressions instead of hard-coding the numbers.

=sum(Sales)>=300000 and sum(Sales)<=500000

Example using aggr() to get Customers with Sales above average but also less than or equal to $160,000

=sum(Sales)>Avg(TOTAL Aggr(Sum(Sales),Customer)) and sum(Sales)<=160000

Example 4.

Filtering using wildcards

Advance search filters supports the use of wildcards. This example filters for all Customer names that begin with  IB or end with EX

=Customer like 'IB*' or Customer like '*EX'

I'm very excited to see the myriad ways this powerful feature will be used going forward. I hope this short introduction gets you started.

- Daniel.

To set up the example project:

• Extract the contents of AdvSearchExamples.zip
• Create a Connection to the Qlik Sense App
• Create the filters as listed in Filter Definitions.pdf
• Import the report. Instructions here 

The attached Migration Playbook is intended to be a consolidation of references for those who are on a QlikView NPrinting 16 to Qlik NPrinting 19 migration journey. It includes migration content from Qlik Community Posts, Qlik YouTube Channels, Qlik Support articles, Qlik Help site references, and guidance from the Qlik NPrinting product team.  Read it from front to back or just selectively review the sections that relate to you - I hope you find this useful!  

Reminder  - this is relevant to  QlikView NPrinting 16 customers only.  If you are on Qlik NPrinting 17+ this guide is not for you.  

For a wider view of additional and important migration considerations 'before' you migrate, please visit:

• NPrinting 16 (deprecated) to 19 and higher versions - Migration Guide

Updated April 28, 2020: change log in V2 document attached. 

So, how to send KPI results to a user by SMS rather than email so you can get a result like the one below. This could be used for daily or hourly status messages to Senior Execs, for operation direction to the salesforce or the distribution team, or for conditional based alerting when KPI results meet a certain criteria. There are so many use cases here... I've also added an example in Arabic (google translate version) to show right to left language capability in the SMS.

It's actually reasonably simple but you do require a 3rd party SMS gateway to perform the translation of an email to an SMS. All telco operators offer these services, and a number of other web based operators too, and all work in much the same way as the example here.

Step 1 - Setup your SMS Gateway provider account

I have used TextMagic for this example as it's easy to work with and offers a free trial with some minimal credit for testing.

• Create your account.
• Setup the basic settings:
  • navigate to Services > Email to SMS
  • Add allowed emails (this is the sender of your email from NPrinting) https://my.textmagic.com/online/emailtosms/emails
  • Edit the send & receive settings to convert the body of the email to SMS and set a limit to how many SMS's it will be converted to. https://my.textmagic.com/online/emailtosms/settings

Other services that will work in a similar way (and may be cheaper)

• Most local Telco providers
• ClickSend - Bulk SMS Gateway & Email Marketing Platform – Email & SMS Marketing

• SMS Country - Send your email via SMS- Email to SMS- SMS Country

• SMS Global - Email To SMS | SMS To Email | Email Text Messages | SMS from Outlook

• Text Anywhere - TextEmail – Send SMS Text Messages from any Email system and Microsoft OMS – TextAnywhere.net

• Esendex - Email to SMS - Send and receive SMS via email - Esendex

Step 2 - Setup your NPrinting instance with the user to receive the SMS

Your SMS gateway provider will indicate the email format for the mobile number you wish to send the SMS to. For example, with TextMagic the format is 4470851234567@textmagic.com for the telephone number +44 7085 1234567 (a clearly made up number).

This is the email address to assign to the user in NPrinting. Note: It is likely that you will have 2 NPrinting user accounts for a single individual if they receive SMS alerts and other reports from NPrinting (hub, newstand, email attachments etc).

Step 3 - Create your HTML report (or import the one attached along with the example application)

The HTML report is very simple. It looks like this in the NPrinting Designer Editor window and is looking at Gauge objects as tables.

Step 4 - Setup your Publish Task

Go through the normal setup process.

• Add the report you have created in step 3 (as HTML output)
• Assign your users (the SMS user you wish to send to as per step 2)
• Check that the destination for the user is email
• In the email section use the tags to embed the report content (and perhaps the users name etc)
• Add a trigger to schedule the report
• Save the changes

Step 5 - run the publish task and receive the SMS

It's pretty easy eh!

Troubleshooting:

• Ensure that your user is assigned to a role in NPrinting. If no role is assigned the email will not be sent.
• Ensure the sending email address, as per the email message in step 4, is included in the TextMagic allowed emails
  • https://my.textmagic.com/online/emailtosms/emails
• Ensure you have some credit left on TextMagic as this will stop things working too...

The names you give your reports can be crucial for aiding people to access the right information quickly. Control the names assigned to your reports with NPrinting by creating static elements in report names as well as inserting arbitrary text, variable elements like cycle field values, and the values of QlikView variables. This tutorial explains how to use the NPrinting dynamic report naming feature.

    

    

        

          

Enable Dynamic Naming

                    

                                

          

1. Put a check mark in the dynamic naming check box by clicking on it
2. The Custom Dynamic Naming section appears.  This allows you to add different elements to your report names

        

        

        

          

Add Elements to Your Report Names

                    

                                

          

Click on the green '+' sign to add another element to the names of your reports. Add more that one if need be.

        

        

        

          

Select Item Type

                    

                                

          

Select the element you want to use from the drop down menu; the following elements are available:

• Report name
• Cycle fields
• Date the report was generated
• Time of day the report was generated
• QlikView variable value of any QlikView variable existing at the time the report is produced
• Recipient name
• Custom text conforming to Windows file name standards

        

        

        

          

Select from Various Format Options for Date

                    

                                

          

Open the drop-down menu and select a format.

        

        

        

          

Choose Separator

                    

                                

          

Select a Separator to divide the elements of the report name, the underscore is the default.

        

        

        

          

Preview The Report Name

                    

                                

          

The report name is displayed in the Preview field at the bottom of the Output File area; variable values are represented by the name of the variable. Note the Custom text field added here in place of the Date field.

        

        

        

          

Changing The Order Of Elements In Report Names

                    

                                

          

1. You can move elements to the left and right in the report name by clicking on the green up and down arrows. Moving an element up shifts it to the left in the name.
2. You can delete single elements by clicking on the red '-'

        

        

    

  

Users should be aware that the NPrinting 17.x repository may be removed in case of a failed upgrade: Upgrading NPrinting?  Read this. Taking regular backups of your files & data is always a good idea anyway and backing up your NPrinting Repository should be no different. Here is a batch file that you could run using your Windows Task Scheduler to automate Qlik NPrinting Repository backups.

Features:

• Accepts the Repository password as the only parameter. Terminates if no password is provided
• Checks to see if services QlikNPrintingEngine, QlikNPrintingScheduler and QlikNPrintingWebEngine are running and stops them before the backup. Starts them after the backup succeeds or fails. Be sure to schedule your backups when there are no other NPrinting tasks running or scheduled to run
• Creates a new compressed file every time and parses date & time to name it
• Logs each step of the backup process to a log file with the same name

To change manually:

• Change this line to specify the backup destination folder: set BACKUPDIR="C:\NPrintingBackups\
• Uncomment the appropriate line with the names of the services depending on the version of NPrinting. Documented in-line

Disclaimer:

• Provided "as is". If you decide to use this batch file please test to make sure it works for you

HTH - Daniel.

Configure your source documents

• Copy SalesDemo.qvw in the Source Documents folder (for instance C:\ProgramData\QlikTech\SourceDocuments)
• Log in the QMC (QlikView Management Console) and you'll see the .qvw in the "Source Documents" tab under "Documents"

Create a QlikView Server Reload Task

• Click on the green "+" (plus) symbol on the upper right corner of the QMC to add a task
• Insert "Sales Demo Reload" as name.

        

Distribute the Reloaded Document to a Folder

In the "Distribute" tab set C:\ProgramData\QlikTech\Documents as distribute folder and select "All Authenticated Users" in the drop-down menu. Use this document in the source connection of the NPrinting project.

       

Trigger the Reload

• Open the "Triggers" tab
• Create a schedule based trigger
• Confirm by pressing "Apply" and try to manually run the trigger to be sure that everything is ok

  

Set NPrinting Service to Accept External Requests

• Open the NPrinting Management Console
• Enable the external requests flag
• Insert the Source Folder. For instance C:\NPrintingTraining\ExternalRequestsXML
• Start the NPrinting Service

It's very important that you know the tutorial "How to Execute NPrinting Reports by External XML" Request very well.

Create the External Request File

In the folder C:\NPrintingTraining\ExternalRequestsXML create the text file QVS.processed. The code to insert is:

<?xml version="1.0"?> 
<schedules> 
<schedule file="C:\NPrintingTraining\NPrintingFiles\NPrintingTraining.nsq" type="job" entityName="Send a Report via Email" />
</schedules>

This will run the job "Send a Report via Email" that must be present in the .nsq file. To create a job refer to "How to Create Jobs"

Create the Batch File

In the folder C:\NPrintingTraining\ExternalRequestsXML create the file QVS.bat with the code:

move C:\NPrintingTraining\ExternalRequestsXML\QVS.processed C:\NPrintingTraining\ExternalRequestsXML\QVS.request

It will rename the QVS.processed file to QVS.request. When the NPrinting Server find a .request file in the External Requests folder it will execute it.

Open the External Program in QlikView Server

1. Select the "System" tab
2. Click on "Supporting Tasks"
3. Activate the "External Program" folder

Click on the green "+" (plus symbol) button on the right corner to create a new task

Create a new Task

• Set "Send NPrinting Reports" as task name
• In the "Command line statement" insert C:\NPrintingTraining\ExternalRequestsXML\QVS.bat.

When activated this task will run the script we saved in QVS.bat

Trigger the Task

• Click on the green "+" (plus symbol) button to create a new trigger
• In the Start the task drop-down menu select "On event from another task"
• Set "successful" on Start on
• On Completion of set "Sales Demo Reload"

In this way you'll trigger the task to start after the finish of the reload and only if it ended successfully. This task runs the QVS.bat file who rename QVS.processed to QVS.request so NPrinting Server starts to distribute the reports.

Allow Application of CSS Inline Style Elements for Whole Chart

After you have added a QlikView object as a table:

1. Right click on the table node
2. Select Properties
3. Deselect the Keep Source Formats box
4. Click on OK at the bottom of the Properties dialog window

This will cause the content for all cells in all columns of the table to be exported from QlikView without formatting. The application of CSS inline style elements that you set in the HTML template will be applied (See section further below: "Allow Application of CSS Inline Style Elements for Specific Columns").

Comparison of Output: With and with out "Keep Source Formats" checked

1. Output sample with Keep Source Formats checked
2. Output sample with Keep Source Formats unchecked

Allow Application of CSS Inline Style Elements for Specific Columns

Be sure that your table object is a straight table in QlikView. Qlikview pivot tables must be converted to straight tables before selecting them to be included under the NPrinting Tables node or you will not have access to individual fields/columns.
If you want to keep source formatting for the majority of columns, leave the "Keep Source Formats" box checked for the table as a whole and proceed as follows:

1. Expand the table node by clicking on the '+' to its left
2. Right click on the node for the column(s) you want to apply CSS inline Style elements to
3. Select Properties
4. Deselect the Keep Source Formats box and click on at the bottom of the Properties dialog window
5. When the HTML Encode box is checked, any non alphanumeric symbols (such as < and />) that could be interpreted as HTML tag elements will be converted to HTML entities. (If the HTML Encode box is unchecked, any non alphanumeric symbols that could be interpreted as HTML tag elements will be rendered by the underlying HTML code used in the NPrinting HTML template editor.)This will cause the content for all cells in the selected column of the table to be exported from QlikView without formatting but will contain application of any CSS inline Style elements you have applied within the HTML template. You can do this for as many individual columns as you need.

Apply Format to a Column

1. Select Gross Profit
2. Enter $#.##,00 in the Format field

Refer to "Which Formats Can I Use in Columns?".

Build Your Table

1. Construct an HTML table with one row, <tr></tr> of table data cells, <td></td>
2. Drag the table column node icons between the table data cell tags. You can select multiple values by keeping CTRL or SHIFT pressed during the columns selection then "drag and drop" them into the template. This will create all tags and insert them into a horizontal series of cells.

Resulting Table

The Keep Source Formats box has been cleared Gross Profit column

Create Column Headings You Can Format Uniformly

1. Insert another row above the first
2. Insert table heading cells in the new row
3. Enter the headings you want

Hide QlikView Table Column Headings

1. Reopen the Properties dialog window for each and every column you have added to the template, one at a time
2. Click in the Value column of the Show Header row, the cell will have the value Show
3. A drop-down menu button will appear at the right
4. Click on the drop-down menu button
5. Select Hide

Current Result

This is the original table with Keep Source Formats cleared for the first and last columns, a heading row added, and the original table headings hidden for each and every column.

Apply Inline Style Elements

Here is the code in full:

<html>
<body>
<table cellspacing=0 style="border-collapse:collapse;">
      <tr style="width:0*;
                          font-family:Verdana;
                          font-size:small;
                          font-variant:small-caps;">
           <th style="border:grey dashed 1px;">
              Product Name
           </th>
           <th style="border:grey dashed 1px;">
              Total Sales
           </th>
           <th style="border:grey dashed 1px;">
              Gross Profit
           </th>
           <th style="border:grey dashed 1px;">
              GP%
           </th>
           <th style="border:grey dashed 1px;">
              Quantity
           </th>
        </tr>
        <tr>
           <td style="width:0*;
                             font-family:Verdana;
                             font-size:small;
                             font-weight:bold;
                             font-variant:small-caps;">
              %%ProductName%%
           </td>
           <td>
             %%Total Sales%% 
           </td>
           <td>
              %%Gross Profit%%
           </td>
           <td>
              %%GP%_1%%
           </td>
           <td style="width:0*;
                              color:red;
                              font-family:Georgia;
                              font-size-adjust:0.40;
                              background-color:Yellow;
                              border:green solid 2px;
                              text-align:right;">
               %%Quantity_1%%
           </td>
        </tr>
</table>
</body>
</html>

Final Result

This sample output is simple but it gives you an idea of the possibilities.

Individual or lists of recipients can be imported by NPrinting and become an integral part of an NPrinting file. Sources include text and Excel files, databases, and LDAP directories. Here is how to import from LDAP directory subfolders.

For the purposes of this tutorial you must:

• launch NPrinting
• open an NPrinting file
• know the IP address of an LDAP directory server, port number, and authentication protocol
• have proper credentials
• know the directory structure parameters

    

    

        

          

Begin Defining Recipient Import Operation

                    

                                

          

1. Select Recipients
2. Select Recipient Imports
3. Click on Recipient Import

        

        

        

          

Select Import Type

                    

                                

        

        

        

          

Open "Import from Directory Service" Dialog Window and Begin Entering Parameters

                    

                                

          

1. Click on From Directory Service in the Import section of the menu bar
2. Enter the IP address of your LDAP directory or Windows Active Directory server
3. Enter the Port number
4. Select the appropriate authentication protocol
5. Put a check in the Use current user credentials box or enter the credentials you have been furnished

        

        

        

          

Connect and Select Base Parameters

                    

                                

          

1. Click on Connect. If all of the above parameters are correct, the Base drop-down menu will open automatically
2. Select the appropriate Base parameter combination

        

        

        

          

Select Path Parameter

                    

                                

          

1. Click on the arrow at the extreme right of the Path field
2. Select the appropriate Path parameter

        

        

        

          

Conclude Defining Source

                    

                                

          

Click on the Execute button

        

        

        

          

Import Recipient(s)

                    

                                

          

1. Click on Import
2. Click on Save

Recipients can be added to or eliminated from the list by using the green '+' and red '-'. When you have finished adjusting the list, click on Import  to import the recipients that you have specified. Click on Save to save this specified group of recipient import operation parameters in the Recipient Imports list.

        

        

        

          

Save and Close

                    

                                

          

Click on the Save and Close icon

        

        

    

  

Background

This approach utilizes a single Source Document with two Publisher tasks.  Each task takes a parameter to define the authentication type.  The value passed will either be USERID or NTNAME.

In conjunction with data reduction, NPrinting report writers will be able to create reports on their own data slice.  This approach can also be used when creating a table for a Section Access based distribution list.

Steps

1. Add a ‘vAuthentication’ variable to your Section Access table to represent the USERID/NTNAME security field.
2. Populate the field with user names in DOMAIN\USERID format.  When USERID is passed, Domain is parsed out. 
3. Note that I have not included a password.  A password will be necessary for USERID authentication if you want to secure this document after USERID distribution.  I recommend adding a PASSWORD column via another variable.  The password will need to be pullled in from a table definition dynamically perhaps using something unique to the users such as last 4 digits of SSN.  If not using USERID, then vPassword would evaluate to no password column.

          a. SET vPassword= ', PASSWORD';

     4. Create two tasks in Publisher.  Both tasks will be able to run without error regardless of the last saved authentication type.

1. One task will distribute the document with NTNAME security to all users. 
   • Because the same Source Document is used for both tasks, the Section Access check box (reserved for USERID access) must checked and set with a USERID that has full rights.  This setting is necessary because the NTNAME task must be able to open the USERID secured document as wells as an NTNAME secured document. 
     1. Set Script Parameter - This setting defines how security will be set in the Section Access table. 
        1. Parameter Name: vAuthentication
        2. Parameter Value: NTNAME. 

          b. The next task will distribute a USERID secured document.

• Check the Section Access check box and set with a USERID that has full rights. 
  1. Set the USERID Script Parameter:
     1. Parameter Name: vAuthentication
     2. Parameter Value: USERID. 
  2. Be sure to save this document to a different mount from the NTNAME distributed document. This location should be accessible to NPrinting report designers. 

Summary

Either task can be executed in any order multiples times consecutively.  Output will be in two separate Document mounts, one with NTNAME security and the other with USERID.

Other Relevant Resources

The approach above can work along-side of the helpful tutorials put together by Jonny Poole on how to use NTNAME with On Demand and user-based filters.

1. https://community.qlik.com/docs/DOC-8935
2. https://community.qlik.com/docs/DOC-8934

Performance Consideration

Consideration must be made to determine whether report designers should be accessing documents hosted on the QlikView server and connected to applications through QVP or through UNC connections. 

The "Use This Group Field" property has been added to the Table column Properties menu in Word, Excel, PowerPoint and HTML report templates. It is displayed only for dimensions and only if they contain a Cyclic Group. It has a predefined value, "(Active Field)" which will use the field which is active at run time. It is also possible to force NPrinting to display a specific dimension by selecting it from the list.

Formula and drill-down groups are not supported.

   

Create New Word Report

                 

                             

       

See: How to Create Word Reports

Set Basic Parameters and Open Template Editor

                 

                             

       

1. Enter a Name for your report
2. Enter a more detailed Description (optional)
3. Click on the New icon in the Template group

Save Template

                 

                             

       

Click on the Save As icon

Save Template

                 

                             

       

1. Enter a File name for the template or accept the suggested one
2. Save as type: can be set to Word Document (*.docx) or the default Word 97-2003 Document (*.doc) as they are both compatible with this feature
3. Click on the Save button

Add Heading and QlikView Object to Template

                 

                             

       

1. Add Top Sales by Category as a heading to Word template
2. Add QlikView object CH305 - Top Sales to template as a table

See: How to Create Word Reports

Set CategoryName as Field to Be Used

                 

                             

       

1. Select the Top Sales column node under the CH305 - Top Sales table node
2. Select CategoryName in the Value cell of the Use This Group Field property in the Properties pane
   
   

Embed CH305 - Top Sales in Template

                 

                             

       

Drag and drop the CH305 - Top Sales table-node token into the template.

   

Add Second Heading and Same QlikView Object to Template

                 

                             

       

1. Add Top Sales by Country as a new heading to the template
2. Add QlikView object CH305 - Top Sales to template as a table again, resulting in the CH305_1 - Top Sales node

 

Set Country as Field to Be Used

                 

                             

       

1. Select the Top Sales_1 - Top Sales column node
2. Select Country in the Value cell of the Use This Group Field property in the Properties pane
   
   

Embed CH305_1 - Top Sales in Template

                 

                             

       

Drag and drop the CH305_1 - Top Sales table-node token into the template.

Add Third Heading and Same QlikView Object to Template

                 

                             

       

1. Add a new heading to the template
2. Add QlikView object CH305 - Top Sales to template as a table again, resulting in the CH305_2 - Top Sales node

Set Salesman as Field to Be Used

                 

                             

       

1. Select the Top Sales_2 - Top Sales column node
2. Select Active Field in the Value cell of the Use This Group Field property if it is not already selected

N.B. Active Field means the field of the group active at the moment of saving the QlikView document. In this case, though we haven't saved the QlikView document, the last active field is Country. If you use Active Field in an Excel report template and add the fields one by one, then you need to set Show Header to Show Above Tag Cell

  

Embed CH305_2 - Top Sales in Template

                 

                             

       

Drag and drop the CH305_2 - Top Sales node token into the template.

Run Preview

                 

                             

       

Click on Preview in the Actions group

Inspect Report Preview

                 

                             

       

Notice that the table has been repeated but the first dimension displays a different field from the cyclic group and the other dimensions show the relevant data.

     

Be Sure to Save Your Work

                 

                             

       

Click on the Save and Close icon.