Data Browser Tricks
Read MoreQViewer Version 4 is Here
Read MoreCreating Temporary Script Associations
Read MoreNum() — Script vs Chart
Read MoreChart Search in QlikView?
Read More
Blog
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 ...
Summary: I review a subtle difference between using Num() in the script vs Num() in charts. I make mistakes so you don’t have to 🙂 2020 marks my 13th year blogging about Qlik. I’m still learning, and still making mistakes! I’ll review a problem I created for myself recently, with the ...
Summary: I demonstrate how to self-collect qvw metadata in a load script and use the metadata to implement a chart search feature in my qvw. Qlik Sense has that cool chart search feature. Can we have the same in QlikView? Something where we can search for a keyword like “price” ...