Tag Archives | QlikView

Information pertaining to QlikView solutions

Qlikview Development Guide – Aliases and Keys

Table Design It is considered a best practice to name tables. Also using a proceeding load with any SQL statements is a best practice. Transformations to field names and expressions are executed faster in memory then over SQL. Field Names Rather than using labels in the user interface, all fields can be aliased in the […]

Continue Reading

Qlikview Development Guide – Commenting

Commenting TRACE or // or /* The REM or TRACE commands should be used to ensure that the name of the table or other relevant notes can be included in the log file. Other developer notes should use // or /* to capture code changes or important information that should be passed on to other […]

Continue Reading

Qlikview Development Guide – Set Up and Planning

Document Needs General dashboard needs should be discussed ahead of time with the end users and clear objective should be outlined. Each dashboard should have its own objective list documented. Items that include core functionality should be outlined and other “wish list” items for subsequent versions should be logged. Data modeling and keys should be […]

Continue Reading

Qlikview Master Calendar Rolling Date Flags

Recently I had to create a calendar QVD generator that creates several flags that are populated with “true/false” based on the given vCurrentDate variable. In order to achieve an accurate timestamp, the date had to be set by pulling the last date from the sales qvd. In this case, it is important that the calendar qvd […]

Continue Reading

Qlikview Migration

To migrate a document from a development environment into production should only involve copying and pasting. No code changes to the QVW should have to occur. If everything is set up correctly, only a reload will need to take place in the new production environment. But rarely do I find this to be the case. Often, […]

Continue Reading

Qlikview Folder Structure

Keeping your Qlikview servers and environments organized can be a bit of a challenge.  I tend to sort all my files within the same structure across all my environments to keep things as manageable as possible. It’s important to maintain the same structure across all your environments. This can make migrating a QVW Dashboard from […]

Continue Reading

QlikView – Complex Dimensions and Expressions  

IF THEN ELSE statements and WHERE [FIELD] IS NULL are common examples of complex scripting within a Qlikview document. Wherever possible, you should look to place all complex formulas and statements within the script of the application and not in the actual dashboard/application objects. Keep the expressions and dimensions as simple as possible in the […]

Continue Reading

Qlikview – Master Calendar

The main method to avoid holes in a calendars and create user friendly fields is to create a master calendar in the data model. A master calendar is a separate table in the data model that a field like OrderDate can link to. When creating a master calendar, I find out what the min and […]

Continue Reading