Qlik Sense Documents

Common Scheduler

Currently NPrinting and QLik (Sense or View) have separate schedulers.

If you reload a Qlik application daily at 1:00AM and want to send the NPrinting reports directly after a successful reload, you must schedule them separately for times that you believe will not intefere with each other. Its better to have a100% chained solution however whereby reports are only distribute upon successful reload of the Qlik app.
Error handling

Should the NPrinting task, publisher has a built in solution to notify administrators. Qlik Sense also has 3rd party solutions to do the same.

Restrictions

You need to have v1.3 of the Qlik REST Connector. Its available as of Feb 2018.

Sample

Connection setup

You will need to create two REST Connector connections to the NPrinting API. One that uses a default HTTP method of "GET" , the other will use "POST" as the default method.

Please reference pages 8-9 of the document https://community.qlik.com/thread/292037 to create the two connections.

Image 1 Get Rest Connection.png

Image 2 Post Rest Connection.png

App Setup

1. Import the attached application and open the script in the Data Load Editor

2. Modify the SETUP tab to reflect your

i. on lines 25/26 update the names of the two REST Connections that you create using the steps in 'Connection Setup' above.

ii. on line 30 , if NPrinting is configured to use https (it is by default) leave this setting to 'Yes' . If you reconfigured it to use http , set to 'No'

iii. On line 31 , set the NPrinting server and endpoint (host + port)

iv: Line 35 is the name of the NPrinting Publish Task that you want to execute

v: Line 37 and 38 is an enhancement to have Qlik check the NPrinting task executions for errors, or , if it runs too long, to abort it and report a failure .

Image 3 Variables.png

3. (optional) You can also Import the following application into Qlik Sense to send an administrative alert. THis is not necessary with QV Publisher as it has an in-built feature to notify administrators when a publish task fails.

4. Open the imported app in the data load editor and update the 'setup' section

i. on lines 21/22 update the names of the two REST Connections that you create using the steps in 'Connection Setup' above.

ii. on line 26 , if NPrinting is configured to use https (it is by default) leave this setting to 'Yes' . If you reconfigured it to use http , set to 'No'

iii. On line 37 , set the NPrinting server and endpoint (host + port)

iv: Line 32 is the name of the NPrinting Publish Task that will alert an administrator about a report failure

(note that i've toyed with using the Notification Web Connector to send an administrative email alert in the event of a full blown NPrinting outage. This sample is a little simpler)

Image 4 Variables.png

Task setup

In Qlik Sense QMC under tasks i've setup 3 tasks .

Task #1 - reloads a Qlik App

Task #2 - Distributes reports in an NPrinting Publish task (this is chained to execute 'on success' of Task #1)

Task #3 - Send an Administrator alert (this is chained to execute 'on failure' of Task #2)

QLIKVIEW

The QLikVIew solution has all the same benefits as the Qlik Sense solution with a couple more benefits.

Additional benefits:

- you can pass the vTask name from the publisher task to make for greater re-usability of the load script for chaining multiple tasks

- Publisher has a built in admin notification feature. SHould the NP task fail, the publisher task will also fail and an admin notification will be sent (you can do that with qlik sense but need to use a 3rd party qlik sense task notification solution, or use the load script to call an administrative task to send a notification. The latter can be done with NPrinting or with the Qlik Web Notification Connector.

Load script

The QlikView load script has a login , get task ID (lookup using task name), post task execution, and a task execution check tab. The task execution check tab will monitor the NP task execution on an interval with a configurable timeout. Should the NP task throw a warning or error, it errors out the publisher task. Should the NP task exceed the timeout, it kills the NP task and errors out the publisher task.

You will need to update the NPServer, Task and timeout settings in the CONFIG tab. Again use the REST Connector 1.3 and i suggest testing with QV desktop first . The REST Connector must be manually installed on QV desktop and on the publisher machine to work.

Image 6 Load Script.png

New cookie parsing:

//Set Cookie header

let vCookieRaw = peek( 'Set-Cookie',0,'_response_header');

if vSSL='False' then
let vCookie= subfield(subfield('$(vCookieRaw)','Path=/,',3),';',1);
else
// let vCookie = TextBetween('$(vCookieRaw)','Secure,','Path=/',2);

Let vCookie = TextBetween('$(vCookieRaw)','SameSite=None,','; Path=/',3);
end if

Related information:

https://community.qlik.com/t5/Qlik-NPrinting-Documents/Run-a-Qlik-NPrinting-API-POST-command-via-QlikView-reload-script/ta-p/1822137

Sheet	Description
Types of CSS implementation	You can add CSS definitions to your app by using themes or by using so-called "helper- objects". On this sheet, I will explain when you should use which option.
Hide (Helper-) Objects	A "helper-object" carries and injects the CSS definition on a specific sheet. This sheet helps you to hide this object and which objects can be used for it.
Colored Area Background	This example demonstrates how to add better guidance to your dashboards by segmenting your background.
Filter Pane Highlighting	Sometimes selections can be mandatory to consume a dashboard, or the creator likes to guide the user through the filter pane by using colored filter boxes. I show you how.
Hiding Button/Options	How to hide objects like the selection bar or elements within context-menus in case these functions shouldn't be used in the app or on this sheet?
Using Background Pictures	Adding background-pictures to your dashboard can spice up the overall flavor of your dashboards. This can be used for segmentation or just to add some style.
Table modifications	In this section, we will completely change the look and feel of a straight- and pivot table.
Moving Objects	Let's create an illusion by just moving our objects closer together. After that, I'll look like we just have one.
Changing standard fonts	This sheet explains the easiest way to implement your own font by using a custom theme. It's just a few lines of code.
Custom Grid Layout	No matching grid? This trick shows you how to create your own grid for a specific sheet by changing the metadata through Qlik Engine API Explorer.

	Excel Formulas	Qlik Formulas
Linear Trendline
Equation	y = m * x + b	y = m * x + b
m	= SLOPE(y,x)	= LINEST_M(y,x)
b	= INTERCEPT(y,x)	= LINEST_B(y,x)

Logarithmic Trendline
Equation	y = (c * LN(x)) + b	y = (c * LOG(x)) + b
c	= INDEX(LINEST(y,LN(x)),1)	= LINEST_M(y,LOG(x))
b	= INDEX(LINEST(y,LN(x)),1,2)	= LINEST_B(y,LOG(x))

Power Trendline
Equation	y=c*x^b	y = c * POW( x , b)
c	= EXP(INDEX(LINEST(LN(y),LN(x),,),1,2))	= EXP(LINEST_B(LOG(y),LOG(x)))
b	= INDEX(LINEST(LN(y),LN(x),,),1)	= LINEST_M(LOG(y),LOG(x))

Exponential Trendline
Equation	y = c e ^(b x)	y = c * POW( e , b * x)
c	= EXP(INDEX(LINEST(LN(y),x),1,2))	= EXP(LINEST_B(LOG(y),x))
b	= INDEX(LINEST(LN(y),x),1)	= LINEST_M(LOG(y),x)
e	= EXP(1)	= e()

2nd order Polynomial Trend
Equation	y = (c2 * x^2) + (c1 * x ^1) + b	y = (c2 * POW(x,2)) + (c1 * x) + b
c2	= INDEX(LINEST(y,x^{1,2}),1)	see example - variable c2
c1	= INDEX(LINEST(y,x^{1,2}),1,2)	see example - variable c1
b	= INDEX(LINEST(y,x^{1,2}),1,3)	see example - variable b

Completion of the Qlik Gallery wizard will result in a new Community post.

Qlik Sense Documents

Qlik Sense Documents

Recent Documents

Introducing Sense Field Formatter

What it does

User Settings

Use Alias as the field's source name

Key Prefix

Comma Position

Field Delimiter

Replace characters

Insert a space before capitals

Change Case

Subfield the field names?

Add Suffix/Prefix?

Reporting solution for Qlik Sense SaaS

Overview

1. Qalyptus Cloud

1-1. Works with Qlik Sense SaaS

1-2. Advanced capabilities to design reports

1-3. Distribute reports with confidence

1-4. Advanced permission management

2. Move to Qlik Sense SaaS when you have NPrinting

2.1 Migrate Qlik Sense for Windows to Qlik Sense SaaS

2.2 Use Qalyptus for your reporting with Qlik Sense SaaS

Introduction

Overview

Basics

Stored or Virtual?

Prerequisites for time-aware charts

Large data sets

Support of Fiscal Years?

Excel Formulas

Qlik Formulas

Linear Trendline

Logarithmic Trendline

Power Trendline

Exponential Trendline

Points to note:

This post is about how to improve the UX of Qlik Sense with no code and no CSS expertise.

UX is what the user perceives when interacting with a product, Service or device.

If you do it right you retain the user, if not, you lose it and get a bad reputation.

UX is lived everywhere, restaurant, in the bank, subway,... of course also in web analytics.

A well-designed UX will go unnoticed, but a poorly designed one is hell.

Here are some intentional examples of bad UX:

Not always but sometimes CSS is necessary to improve the UX and get a high customizable app:

To avoid the definition of complex CSS code I propose to use this extension that allows a high customization through a visual and assisted interface.

Available through this link BeautifyMe (contains a qvf example)