Author Archive | Christina Adams

Qlikview Developer Macros

When I am designing a Qlikview application, I often create a sheet that is essentially a draft area. It’s a place where I can drop text boxes, list boxes, and all manner of items that have nothing to do with the actual dashboard. This sheet is just for me to run tests and validations; I […]

Continue Reading

Qlikview QVD loop

Sometimes I need to pull in a long list of tables or views and I want to pull in all the fields available to me. A fast and easy way to do this is by simply looping through all of them with load ‘*’ (all). The names of the tables or views being pulled should […]

Continue Reading

Qlikview Sub Routine

Few people know that qlikview code can be set up within sub routines. I find this to be a very helpful tool to use in situations where I may not want to reload the entire script. The most common use case for me is the QVD generator. Often times while I am developing, I only […]

Continue Reading

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