Another post in the “Best of QlikCommunity” series.In this QlikCommunity Forum thread the poster asked about using the class() function to create a dynamic dimension of 30 minute intervals in a chart. He wanted to format the class values as display friendly time ranges. My solution would have been to ...
Read More

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