Wouldn’t it be nice to know what fields are “unreferenced” in your document? By unreferenced, I mean fields that are not used in Expressions, Dimensions or Keys. These are fields that if removed from your document, would have no impact on the visible elements of the application. Removing unused fields ...
Read More

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

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

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

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