QViewer Version 4 is Here
Read MoreCreating Temporary Script Associations
Read MoreNum() — Script vs Chart
Read MoreChart Search in QlikView?
Read MoreParsing Non-Standard Signs
Read More
Blog
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” ...
Summary: I demonstrate using Num#() and Alt() functions to read numbers with non-standard signs. Download link at bottom of post. When reading from text files, the default Qlik interpretation of numeric sign syntax is as follows: 100: No prefix, positive number +65: “+” prefix, positive number -110: “-” prefix, negative ...