I use the following 2 generic scripts often in my development live Cycle.
Store and Drop all the Qlikview tables in your Model. This can be applied in the RAW or Functional Data Layer.
let noTabs = NoOfTables();
set name = '';
let noTabs = NoOfTables();
set name = '';
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');
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;
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.
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.
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.
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.
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.