Blog

BOQC: ApplyMap instead of Join

Today marks my first blogging of “Best Of QlikCommunity” (BOQC) where I plan to highlight what I find to be particularly useful or interesting posts on the QlikCommunity Forums. There are cases when the ApplyMap() function is a very useful alternative to Join. For some time I have noticed both ...
Read More

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

Recipes for Qlikview Success