Data from Websites

Loading partial data

We show you how to download and extract data from a website when the data has to be manipulated because you only want some of it.

Watch the video at full resolution

Download and use the files

Download the files used in this part of the tutorial.

How to use the downloaded files:

1. Unzip the file to a folder.

2. Open the qvw file in QlikView.

3. Look at the load script in the editor to see how the example works.

Accessing the rest of the tutorial

Click to access the rest of the QlikView Developer Tutorial

As for any operations made via user interface also the APIs require authentication before allowing anyone to deal with them. Few realize how to deal with the authentication phase before calling an API end-point, here a short example on how to authenticate against NPrinting before made any API call, using python.

The example attaches attempt a call to the start a task, but any and-point can be made using the same logic.

Before start, we need to download the NPrinting Certificate from the browser. One connected to the NPrinting, Browser warning us about the self-signed certificate. You should be able to download it and locate near the script.

Let's start with the required imports

import sys

import requests

import json

from requests_ntlm import HttpNtlmAuth

Then we need to replace a number of variables used the deal with the endpoints (rows 6 to 13)

The actual authentication phase needs to be called just once, in the example function Auth(). If the authentication succeeds, the response contains a cookie called  NPWEBCONSOLE_XSRF-TOKEN. All subsequent calls need to echo the same cookie and set an header variable called  X-XSRF-TOKEN with the same value.

Qlik NPrinting is the reporting platform for QlikView and Qlik Sense. A report generation process can virtually generate a customized report for each user, starting from the same report template, based on the user profile. Also, the report distribution channel can be differentiating for users or groups, subsequently the users list is one of the critical parts to manage.

NPrinting offers an out of the box method to import users from a third party directory  here which requires accommodating the list of users to import into a preformatted Excel file and create a task to run the import process on a schedule base or just in one shot. It’s up to you to take care of the exporting process from the user’s source directory.Starting from the June 2017, NPrinting has released also a set of APIs which allows building your own importer.

Waiting for a more integrated user management solution, covered soon by the product, a couple of extensions has come out. One is the “Import Nprinting Users from Active Directory” from Erik Gustafsson (a command line tool for import users coming from AD). The other is this one, which targets a more generic LDAP and offers a web interface to connect and map the metadata.

You can find the software on Branch (here ) or GitHub (here ) with a 3 minutes’ video tutorial showing the process from the download to the user's import.

Requirements:

Requires Node.js

Installation:

Just download the latest version and unzip it to the desired folder. To start the process type “npm start” from the unzipped folder

Here the video tutorial:

"Did you know that you can use the QvsAdminDataProvider.dll in the script editor to find out even more system meta data information? As long as you are a QV Administrator, all system collaboration meta information, document attributes, and even document list attributes can be pulled from QVS just by using this simple connector in the script editor. "

/Michael Terenzi, Designated Support Engineer

Data from databases

Adding an ODBC connection in Windows

We show you how to setup an ODBC connection in Windows.

Watch the video at full resolution

Accessing the rest of the tutorial

Click to access the rest of the QlikView Developer Tutorial

Data from databases

Getting and preparing databases

This video shows you how to get the database files used in this project and prepare the database files for reading.

Watch the video at full resolution

Accessing the rest of the tutorial

Click to access the rest of the QlikView Developer Tutorial

Data model

Making new fields

The video shows you how to make new fields from existing fields.

Watch the video at full resolution

Download and use the files

Download the tutorial files used in this part of the tutorial.

How to use the downloaded files:

1. Unzip the file to a folder. All the files go in the same folder.

2. Open the qvw file in QlikView.

3. Look at the load script in the editor to see how the example works.

Accessing the rest of the tutorial

Click to access the rest of the QlikView Developer Tutorial

Data from websites

Clean Data

In this example, we show how to download and extract data from a website when the data is clean and you don't need to manipulate it.

Watch the video at full resolution

Download and use the files

Download the tutorial files used in this part of the tutorial.

How to use the downloaded files:

1. Unzip the file to a folder.

2. Open the qvw file in QlikView.

3. Look at the load script in the editor to see how the example works.

Accessing the rest of the tutorial

Click to access the rest of the QlikView Developer Tutorial

Data from websites

Spreadsheets from websites

Sometimes data on websites is in the form of a spreadsheet. You can download the spreadsheet as a file and load it into into QlikView, or you could just directly read in the spreadsheet. Learn how QlikView can read in spreadsheets directly from web pages.

Watch the video at full resolution

Download and use the files

Download the tutorial files used in this part of the tutorial.

How to use the downloaded files:

1. Unzip the file to a folder.

2. Open the qvw file in QlikView.

3. Look at the load script in the editor to see how the example works.

Accessing the rest of the tutorial

Click to access the rest of the QlikView Developer Tutorial

Data from websites

Data cleansing

Sometimes, data has unwanted extra characters or other unwanted features. This video shows how data from websites can be cleansed using QlikView.

Watch the video at full resolution

Download and use the files

Download the tutorial files used in this part of the tutorial.

How to use the downloaded files:

1. Unzip the file to a folder.

2. Open the qvw file in QlikView.

3. Look at the load script in the editor to see how the example works.

Accessing the rest of the tutorial

Click to access the rest of the QlikView Developer Tutorial

"Due to a limitation associated with using Microsoft’s COM objects we recommend that you limit the number of QlikView Engines (QlikView Enterprise Management Console>> System>> Setup>> Distribution Services>> Advanced tab) to a maximum of 9 or the number of processor cores available on the host server -1, whichever is lower.”

If you have more than 9 processor cores, and wish to run more Engines, contact Support for information regarding a registry change to the Desktop Memory Heap settings on the server."

/Troy Raney, Technical Support Engineer & Team Mentor

Data from spreadsheets

Simple data

This video show you how to read data from a simple spreadsheet.

Watch the video at full resolution

Download and use the files

Download the tutorial files used in this part of the tutorial.

How to use the downloaded files:

1. Unzip the file to a folder. The qvw file and the Excel file should go into the same folder.

2. Open the qvw file in QlikView.

3. Look at the load script in the editor to see how the example works.

Accessing the rest of the tutorial

Click to access the rest of the QlikView Developer Tutorial

Doing an upgrade of QlikView Server will put all installed QlikView services into Startup Type = Automatic, causing the services to start on next reboot, although previously configured to be disabled.

This may lead to undesirable results in situations where all services has been installed, although not required. One scenario is when setting up a cluster, doing a full installation of QlikView Server on each node and later disabling the QlikView Management Service on each node, except the main node in the cluster.

It is recommended to only install services required on each node in the cluster, using a custom installation, rather than disabling installed services.

In case of having QlikView services set to Startup Type = Disabled, make sure they are configured properly after an upgrade to prevent undesirable results on next reboot.

General

Q: Where can I download the new Qlik NPrinting version?

A: Existing Customers and Partners can download Qlik NPrinting from the official Qlik download page.

Q: What versions of QlikView are supported for NPrinting?

A: All current officially supported QlikView versions are supported to be used together with NPrinting

Existing NPrinting customer

Q: Where do I go for support if I'm an existing NPrinting customer?

A: If you are an existing NPrinting / Vizubi customer, support will continue as before. Learn more about Qlik support services or get help through the channels listed here

Q: Am I forced to upgrade to the new Qlik NPrinting version?

A: No. You can continue to use your current version of NPrinting as before. However we strongly recommend you to upgrade to Qlik NPrinting as soon as possible.

Q: Will upgrading to Qlik NPrinting affect my existing NPrinting projects?

A: No. Qlik NPrinting is fully compatible with previous NPrinting version. Except for upgrading the software, no further actions should be required.

Q: Will Qlik continue to provide updates to my current NPrinting version from Vizubi?

A: No. The current version of NPrinting from Vizubi will be discontinued and no future updates will be provided for  this version.

Q: What about my current maintenance agreement?

A: Your current maintenance agreement with Vizubi will continue as before. After expiration it will be transferred to Qlik maintenance policy, found here.

If needed, please contact Qlik Support on http://www.qlik.com/support

"The user accounts running QlikView Server services must be a member of the local machine’s Administrators group AND the QlikView Administrators group."

/Troy Raney, Technical Support Engineer & Team Mentor

A document for setting up Qlik Sense 2.x Virtual Proxies for header injection.  The attached document walks through the steps to configure a virtual proxy in Qlik Sense 2.x and test connectivity with Fiddler and Postman Chrome Extension.

This document is very similar to Qlik Sense 1.1: Set Up Header Auth Virtual Proxy with some updated screen shots related to new flow.

This is a companion document for the following documents:

QRS API - Removing Unwanted Users with PowerShell

Displaying data

Gauges and population pyramids

The video shows how you can create a gauge and a population pyramid.

Watch the video at full resolution

Download and use the files

Download the tutorial files used in this part of the tutorial.

How to use the downloaded files:

1. Unzip the file to a folder. Both files should go in the same folder.

2. Open the qvw file in QlikView.

3. Look at the load script in the editor to see how the example works.

Accessing the rest of the tutorial

Click to access the rest of the QlikView Developer Tutorial

What is Qlik DataMarket?

Qlik DataMarket is a cloud-based Data as a Service offering (DaaS) with a wide range of data, ready for use with Qlik products. Example of data sets are

• currencies
• weather
• demographic data etc

Qlik DataMarket is provided using a Freemium model, with limited number of data sets available for free, and additional data sets provided through a subscription model.

Connectivity to Qlik DataMarket is embedded into Qlik Sense and as a stand-alone connector for QlikView.

How will Qlik DataMarket be licensed?

Qlik DataMarket is licensed through a separate License key and control number inside the Qlik Sense Management Console.

A limited set of data will be available for free and additional data sets can be bought, using a subscription model, through QlikBuy.

It will not be possible to license Qlik DataMarket packages (such as Essentials Package) in Qlik Sense Desktop. Only free data sets will be available in Qlik Sense Desktop.

Is it possible to preview data without a subscription?

Yes, it is possible to preview limited data from a licensed data set, without a paid subscription. However it is not possible to connect and download data to your app.

What happens to data in an app if subscription lapses?

If a subscription lapses it will no longer be possible to receive updated data. However data already stored in the data model will still be available for use within the app.

Is Qlik DataMarket only available for Qlik Sense?

Qlik DataMarket is a bundled feature in Qlik Sense 2.0, so no additional installation is required, although a separate license may be required.

For QlikView a separate custom connector is required, which is expected to be released later in 2015.

Can Qlik DataMarket be used outside of Qlik products?

Currently it's not possible to use Qlik DataMarket to feed into third party products.

Is it required to have a live internet connection to use Qlik DataMarket?

Yes, as Qlik DataMarket is provided as a cloud-based data service, internet access is required when updating / reloading data.

Qlik Apps already populated with data does not require internet access, unless the data needs to be updated.

How is data transferred from Qlik DataMarket?

Data is fetched from Qlik DataMarket's cloud service using encrypted https communication

Where is data physically stored in Qlik DataMarket?

Qlik DataMarket is hosted on Amazon AWS instances and data is stored in locations around the globe.

This QlikView Enablement module will provide you with that next level of troubleshooting when it comes to Section access. Section Access is a way to limit user Access to the data within a QlikView application. This document will cover some of the most common issues and how to troubleshoot them.

Watch in full screen and in a higher resolution for best results.

Author: Toni Kautto