Effective Visual Communication

Now you own a brand new power saw (Qlikview). But do you know how to build a house? A key feature of Qlikview is graphical representation of data. Do you have the skills to use that capability effectively? The challenges of effective visual communication are not unique to Qlikview. The ...
Read More

Using MapSubstring() to edit strings

The MapSubstring() function is a powerful alternative to using nested Replace() or PurgeChar() functions. MapSubstring(), unlike it’s siblings ApplyMap() and Map, will apply multiple mappings from the mapping table. Here’s an example.ReplaceMap:MAPPING LOAD * INLINE [ char replace) ) ” , / – ] (delimiter is ‘ ‘); TestData:LOAD*,MapSubString(‘ReplaceMap‘, data) ...
Read More

The design of grouped objects

I recently submitted a feature request to Qliktech requesting “grouped objects”. There are a number of issues to consider when thinking about how grouped objects should be implemented in QV. You are probably familiar with the idea of grouped objects. It’s a feature commonly available in graphics authoring programs Select ...
Read More

Extracting data using Microsoft Logparser

I’ve fielded several questions lately about loading Group membership information from Active Directory. The Active Directory sample in the Qlikview Cookbook uses AdsDSO and can load “single-valued” fields such as Name and Mail. AdsDSO will not load “multi-valued” fields such as “memberOf” or “member” — fields that define group members ...
Read More

Using the Evaluate API in Macros

A common application of QV macros is to make initial selections. These selections may be applied when the document is opened, a sheet is activated or a button is pressed. The selections usually involve some type of dynamic value, such as “today()”.In the examples below, the VBS continuation character “_” ...
Read More

Recipes for Qlikview Success