BOQC: Flexible Interval Classification
Read MoreAnalyzing Field Usage in a QVW
Read MoreBOQC: ApplyMap instead of Join
Read MoreEffective Visual Communication
Read MoreUsing MapSubstring() to edit strings
Read More
Blog
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 ...
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 ...
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 ...
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 ...
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) ...