Blog

Creating Temporary Script Associations

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 even identify ...
Read More

Num() — Script vs Chart

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 ...
Read More

Chart Search in QlikView?

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” ...
Read More

Parsing Non-Standard Signs

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 ...
Read More

Making it Touchy

I like my apps to work like dog toys. When I poke them, they should “squeak”.  I find myself poking at screens with my mouse or finger wondering “What’s this?”. When I build a QlikView app I try to make it “touchy”.  That is, if a curious user pokes at something ...
Read More
Loading...

Recipes for Qlikview Success