Can I Update a Mapping Table?
Read MoreCubeTester
Read MoreData Browser Tricks
Read MoreQViewer Version 4 is Here
Read MoreCreating Temporary Script Associations
Read More
Blog
Summary: Can you concatenate rows to a Mapping Table? The answer is “Yes” and I show you how. Recently my Masters Summit colleague Oleg Troyanksy asked me “What are the limits on updating an existing Mapping Table in Qlik script?”. My immediate answer was “You can’t update a Mapping Table ...
When working on Qlik Sense performance issues I frequently find I want to measure the performance of specific expressions. I might want to know how variations of an expression may perform against each other. In a slow chart with many measures I want calculation time individually for each measure to focus ...
Summary: I demonstrate my latest “Data Browser” sheet for use in Qlik data modeling. Download here. Today I want to share the latest version of my “Data Browser” sheet. What’s a “Data Browser”? It’s my name for something you may already have. The ubiquitous “System Sheet” or sometimes “Profiler” where you may have listboxes or charts ...
QViewer, the ubiquitous QVD file viewer, has received a major update. In addition to the fast and beautiful QVD viewing and filtering you are used to, V4 introduces “Folder View”. Folder View allows you to work with folders and subfolders of QVDs, viewing details and opening QVDs from the list ...
Summary: I review using Join, Lookup() and ApplyMap() as script techniques to calculate using fields from multiple tables. I ultimately recommend ApplyMap(). Qlik charts can calculate values on the fly, using fields from multiple tables in the model. The associative model takes care of navigating (joining) the correct fields together. Our expression syntax doesn’t identify what ...