Tag Archives | QlikView

Information pertaining to QlikView solutions

Qlikview – Inputbox as a filter

Recently, I was working with a client who wanted to make it easier for end users to be able to do complex associative searches in a list box. A few examples of how associative searches can be used in order of increasing complexity: 1) Search for all Suppliers whose name starts with the letter S […]

Continue Reading

Benchmarking QlikView Load Script Strategies

I recently worked on a project that involved improving the performance of a user developed QlikView document load script. The problem I was told was that the reload took approximately 12 hours to complete. The request that I received was to examine the document and improve the data model and load strategy. One issue that […]

Continue Reading

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

Improving Qlikview Export Quality Image

I was at the Ohio Qlik User Group meeting today and saw a very interesting presentation from Mike Czerwonky that I thought should be shared with our readers. For the longest time, users have been copying static images of charts/graphs from Qlik into PowerPoint, Excel, emails, etc… With the goal of sharing information with other […]

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

Configuring QlikView Server for Multiple Authentication Types – Part 2

In Part 1 of this blog post we examined the configuration steps required for accepting multiple types of authentication when connecting with a single QlikView Server (QVS).  In any multiple authentication scenario, the default document authorization mode must be changed from NTFS authorization to DMS authorization as shown in Figure 1. This is because NTFS […]

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