Welcome Guest, you are in: Login

QVSource: The QlikView & Qlik Sense API Connector (Docs)


The demo application provides a way of comparing a brand or companies Facebook presence with that of competitors or other companies in their (or indeed any) sector. You can see a live running version of this application here.

It uses the latest Facebook Fan Pages & Groups Connector v2 and the Sentiment Analysis & Text Analytics Connector.

Download

IMPORTANT - Please check which version of QVSource you using in order to download the correct version

  • If you are using a version of QVSource before 1.4.7.1, this starter application will not work
  • If you are using a version of QVSource between 1.4.7.1 and 1.5.3.5, then please visit our QVSource repository on GitHub in order to download the application. It will no longer be updated as it uses the Facebook Pages and Groups Connector v1, which is being deprecated.
  • If you are using QVSource 1.4.5.6 or later, then you can download the latest Zip file here or you can visit the QVSource repository on GitHub here where you can track changes and download it.

If you are using an older version of QVSource, then you should look to upgrade to the latest version as soon as possible.

See the 'Change Log' tab in the application load script for a list of changes in this version.

We are starting to move our QlikView applications over to GitHub.

To understand why we are doing this and what it means to you, we have written this page.

Usage

The demo download should be composed of a QVW file and a TXT file as illustrated below.

Image

The idea is that all the configuration (for the Facebook pages to load, max number of items etc.) are contained in the config (.txt) file. The top of this config file is reproduced below. We would recommend that you carefully read through the comments in the real config file for a better understanding of the options available - however in most cases you should only need to edit the values shown below.

When working out what to enter in the page field in the FacebookSites config table below you should read the relevant docs for the connector here.


// --------------------------------------------------------------------------------------------------------
// THE FOLLOWING SHOULD BE REVIEWED BEFORE RELOADING THIS APPLICATION
// --------------------------------------------------------------------------------------------------------

//
// Edit the following table so that the left column contains the 
// FB page name or id and the right column contains a friendly name
// to be used in charts.
//
// You should read the docs here:
// http://wiki.qvsource.com/Facebook-Pages-Connector-for-QlikView.ashx#Facebook_Name_or_Page_Id_0
// when working out what to enter for the page field.
//
// The first row should be your own company's page (it is used to set the 
// vCompany variable which may be used to highlight lines in certain charts 
// in the future).
//
FacebookSites:
LOAD * INLINE [
page, Site
internetexplorer, IE
googlechrome, Chrome
Firefox, Firefox
];

//
// The first time the app is loaded (i.e. when there are no saved QVD files) it will go back from 
// the current day this many days and retrieve all the feed items. Note that if the facebook fan 
// page has a lot of activity then it can be very slow to load the further back you set this.
//
let vNoDaysToGoBackOnInitialReload = 14;

//
// After the first reload (i.e. when there are some saved QVD files) we still want to go back a short 
// time to pick up any new comments, likes etc. for posts that may have changed since the previous loads.
// This variable sets how many days we go back refeshing feed items and associated comments for.
//
let vNoDaysToGoBackOnSubsequentReloads = 3;

//
// There could be hundreds of comments on each facebook post - this value sets the maximumn number of comments
// to retrieve per post. Note that the more you retrieve the slower the reload will be.
//
// Please note that the data for each feed item actually contains a field with the total number of comments for the 
// post which can be used for charting so unless you actually require the text, like count and other comment specific 
// text you could set this to 0.
//
let vNoOfCommentsToLoadPerFeedItem = 10;

//
// Configure this table with one or more of the following sentiment APIs:
//
// Repustate
// TwitterSentiment
// Alchemy
// Viralheat
// Chatterbox
// Random
//
// NOTE:
// - You may need to ensure you have API keys configured in QVSource for the selections you make here with 
// enough quota to be able to score all the content.
// - The QVSource Sentiment Analysis & Text Analytics Connector also connects to other APIs which you can 
// of course also use however you would need to modify the load script accordingly.
//
SentimentAPIs:
LOAD * INLINE [
SentimentAPI
Random
Repustate
];

And changing it to a value of your choice.

Please note the following two points:
  • It's possible that the Facebook page might not even contain vNoOfCommentsToLoadPerFeedItem comments or might contain more than you configure here.
  • The higher the settings for vNoDaysToGoBackOnInitialReload, vNoDaysToGoBackOnSubsequentReloads and vNoOfCommentsToLoadPerFeedItem, the slower the reload will take (assuming there are this many items). This is primarily due to the large number of individual separate requests which need to be made to the sentiment API. The response from the Sentiment API should be cached by QVSource however meaning subsequent reloads will be faster.

Loading

Once you have edited the necessary parts of the config (.txt) file and saved it you should be able to reload the QVW file (don't forget to make sure QVSource is running).

Please note: If you have done a reload with one set of Facebook sites configured and then you change this list of sites you should also delete all QVD files alongside the QVW file before reloading the new set of sites, otherwise you will have a mix of data.

Daily Reloads

You can also set this application up to reload daily. See the instructions here and here for getting started on this.

This application is actually designed with this in mind and after a number of daily reloads you will also be able to show additional KPIs such as how the number of likes for each site is changing over time.

Screen Shots

Image

Image

Image

Image

Image

Schema

A couple of notes on the below:
  • By default vLoadPostersAndCommenterInfo is set to 0 in the config file and the FB_Posters and FB_Commenters are not loaded. This is because it takes a long time to build these tables (currently one individual QVSource request for the user id of every poster and commenter) and typically the only additional information gained is the gender and locale of the user.
  • The users in the AllContent table have now been split out into a separate AllUsers table.

Image

Change Log

Please see the change log on the 'Change Log' tab of the load script.


(QVSource works with Qlik Sense as well as QlikView - See this page for notes.)
QVSource - The QlikView & Qlik Sense API Connector | © Copyright 2011 - 2016 Industrial CodeBox Ltd