Blog

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

qcb-qlik-sse, A General Purpose SSE

In Qlikview we have the ability to add function to the scripting language by writing VbScript in the document module (sometime called the “macro module”).  Typical  additions included regular expression matching & parsing, Qlik Sense does not have the module feature, but both Sense and QlikView share a similar feature,  Server Side ...
Read More

Load Master Items in Script?

At the Masters Summit for Qlik, I always try to show something new and cool.  At past events I’ve shown things like Alexa selections in Qlik Sense and the new Document Analyzer for Qlik Sense. So what do I have lined up for the upcoming Amsterdam and Washington DC events? In ...
Read More

Recipes for Qlikview Success