You are here


QlikView: Using Q-Eye to view resident tables.

Q-Eye is a great tool for viewing and editing QVDs, but Q-Eye can also be used to view resident tables during a reload.

1.       Download and install Q-Eye.

2.       Add the following sub to the beginning of your QlikView script. If you did not install Q-Eye in the default path or you are using the portable version, you will need to change the values for the path variables.

sub EyeTheTable (xTableName)
    let xProgramFilesPath = GetRegistryString('HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion', 'ProgramFilesDir');

How to build stylised QlikView Applications without any customisation

Customisations and extensions are powerful and cool and sometimes there is no other way to achieve your objectives, but did you know you can make QlikView Applications look and navigate like Rich User Interfaces by doing some of the following:

1.       Less borders – use less borders and when you do, use thinner lines drop the rounded corners;

2.       Softer (pastel) colours – these are easier on the eye and more appealing to users; 

3.       Transparent objects - Especially graphs;

5.       Use these same actions to set variables that you will use to control colours;

6.       Use text boxes to navigate by:

a.       Adding your actions (point 5) to these text boxes;

The Significance Of QlikView

Qlikview NPrinting

Individuals who are reliant on BI have long discovered the significance of QlikView Business Discovery Platform.  The platform and associated services have been growing rapidly over the past decade.  The platform is renowned for its capacity to assist users in uncovering insights that have been overlooked by other BI tools.  It is also known for its use of visualizations, which make it easier to comprehend and explain to others. 

Removing QlikView Backend (Script) Variables from the Frontend


In QlikView, variables created in the backend (script) are automatically available for use in the frontend. The problem with this is, that you don't always need all the script variables in the frontend. These can be variables used for things like loop counters and variables for storing table names and files locations, etc.

A Concise Guide To The QlikView BI Platform

QlikView south africa

What is Business Information (BI) Platform?

BI platforms are important to any business. They allow businesses to use information spun from raw data for the purposes of analysing their business operations and growing their businesses. In many instances, they can be the literal difference between success and failure because of the perspective and direction such information can help give a business in going forward successfully. 

Explaining QlikView.Next: The Next Generation BI Platform.

Qlikview NPrinting

The QlikView Business Discovery Platform has long been a favourite among those who rely on BI. The platform and QlikView's associated services have experienced rapid growth over the last decade, growing to more than 1,000 clients in South Africa alone by 2012. The platform is known for its ability to help users uncover insights other BI tools overlook, as well as putting data into visualisations that make it easy to understand and explain to others who may not be as fluent in BI. The next generation, known as QilkView.Next, is designed to do this in an even more intuitive way. This will allow users to better analyse, visualise and interpret data, making it more useful in making decisions that grow their businesses. 

Understanding Qlikview Data Sources


Lots of companies use data warehouses to obtain a single data source. Much of the time, this is only of limited help, because it takes too long to generate and maintain reports for users. Recently, QlikView launched its' “Direct Discovery” feature, which makes a data source database accessible to reports on demand. In its' standard settings, QlikView uploads all the necessary data into a column store database in advance. However, when needed, the Direct Discovery function enables it to access data from SQL data sources, to complement the column store database. To analyse your information, you can combine sources of data from different suppliers and vendors into one QlikView application.

Introduction to QlikView: How It Can Help Your Business Grow

qlik sense
Introduction to QlikView
The most successful businessmen in the world will tell you that the key to staying on top is to keep up with innovation brought about by technology. If you are working for a large corporation and you are currently thinking of ways to improve your company's systems and operations, you need to invest in top-of-the-line software to provide your company with the best solutions. One of South Africa's most trusted names in business information technology today is QlikView. The system's Business Discovery platform provides your company with true self-service business intelligence that can empower your business with innovative means of decision-making.