Blog

Q. Explain Qlikview architecture? QlikView deployments have three main infrastructure components: 1.QlikView Developer :  Is a Windows-based desktop tool that i…

This tutorial gives readers an overview and talks about the fundamentals of QlikView. WHAT IS QLIKVIEW AND ITS COMPONENTS Qlikview does in-memory data process…

Set Analysis QlikView has a feature called SET ANALYSIS that directs us a way to add context to a dashboard. When we make selections on certain variables, the …

Using Visual Cues Visual cues are a handy (and perhaps simpler) way to create visual color alerts in tables. To create a visual cue, follow these steps: Hol…

Dimension Limits One of the simple requirements while comparing data is limiting the dimensional values on the chart. ‘Dimension limits’ are a feature that can…

Optimizing Your QlikView Application User Interface QlikView has very user friendly visual interface. QlikView makes it very easy to pull the data in and prese…

Layout Tips for Developers This post describes basic qlik view objects layout tips and design, themes, dimension limits, containers, calculated colors, as well…

Debugging Understanding debugging process is very important for troubleshooting. This post describes how to use the qlikview tools and functions, helping you i…

Creating QVDs with QlikView publisher Qlik view administrators with the proper admincredentials may now (with qlik view11) generate QVDs directly from the qlik…

Creating QVDs (QlikView Data Files) Creating a QVD file or files is important because, when working with large sets of data, it is these native file types that…

QlikView Data Files QlikView QVDs play a crucial part in the majority of QlikView implementations. What Is A QVD? Basically, a QVD is a flat data file with t…

Using Metadata If you do not know your metadata, you do not truly know your data. With the release of Qlikview 10, the ability to add metadata was added as a f…

Data Islands Sometimes you want to create a link between two tables where no link exists.  A table that does not have any associations to other tables is calle…

IntervalMatch Function IntervalMatch is used to link a discrete numeric value to one or more numeric intervals. QlikView IntervalMatch is a powerful function u…

Table combining and concatenation Concatenate appends the rows of one table to another. Concatenate never merges any rows. The number of rows in a concatenated…

How to Rename Fields using Mapping Table Renaming fields in the script are something that all QlikView developers do, not only for creating links between table…

Fixing circular references and removing synthetic tables in Qlikview: The good thing about the Qlikview data model is that tables get automatically connected t…

Advanced Scripting in Qlikview and Data Model Optimization The Single most significant factor in whether a QlikView project is a success is a well designed dat…

Qlikview table viewer – Previews Records in Tables: The QlikView table viewer is a graphical tool that a QlikView developers use to visualize the QlikView data…

This chapter describes how the QlikView Table Viewer can assist you in creating a logical, efficient data model. The QlikView Table Viewer can assist you in doc…

Synthetic keys in Qlikview : ‘Synthetic keys occur when two or more tables have two or more fields in common.’ However, when we have more than one common field…

Qlikview Data Model,Exporting Images & Structures and best practices: QlikView Data Model best practices dictate that, a star schema is desirable whenever poss…

Snowflake and Star Schema in Qlikview Star and Snowflake Schema are the two data models in qlikview. In STAR schema all the facts are stored in one central …

Script Expressions & Quotation marks in Qlikview In the script, the name of the data source, the name of the table and the name of the field, included in the l…

A Regular statement or script control statements: QlikView scripts consist of a number of statements and expressions. A statement can be either a regular scrip…

Qlikview Rename Field, Qlikview Qualify  To build the association between data fields, QlikView primarily uses field names as the main identifying factor. Rena…

Qlikview Scripting Features and Functions Scripting is a very powerful feature in QlikView, which enables control of the data load options and data transformat…

DATA TRANSFORMATIONS IN FLAT FILES Data Transformation is the process of modifying the existing data to a new data format. It can also involve filtering out or…

The QlikView Script Editor is the main workplace for developing the scripting elements of QlikView application. Some useful features in the Script Editor includ…

OLE DB/ ODBC connection to data sources in Qlikview New users of QlikView will often create a new QlikView document (application or QVW (QlikView Worksheet)) b…

In this tutorial we will learn about how to create a QlickView Script. The script is a code that controls data connections, extractions, modification, associat…

Getting the best Business Intelligence platform is vital in enhancing your company’s productivity. Even though Qlikview, Tableau and Looker are classified unde…

Overview of Qlik SAP Connector 6.4: The Qlik Connector for use with SAP NetWeaver is installed with the QlikSAP_X64Setup.exe. It is comprised of 64-bit (x64) a…

Qlik NPrinting is the reporting platform for QlikView and Qlik Sense. Qlik NPrinting create reports from QlikView Documents and Qlik Sense apps. It then distrib…