Blog

The match() Function

In SQL, the “in” operator is commonly used to test if a value exists in a list of values. For example: SELECT * FROM TABLE WHERE CODE IN (‘a’, ‘b’, ‘f’); New QV developers often spend some time looking for QV’s equivalent of the “in” operator. It’s the match() function ...
Read More

An Example is Worth a Thousand Thread Replies

There’s a lot of information being exchanged on the QlikCommunity Forum http://www.QlikCommunity.com these days. Customers and Consultants ask technical questions, and other Customers, Consultants and QT employees provide very useful answers. Today’s post is a tip on how to improve the chances of your Forum question being answered quickly and ...
Read More

Loading Multiple Excel Sheets

Load from Excel is usually pretty straightforward, but sometimes you’ll need to load multiple sheets and make some determinations at runtime. Details such as sheetnames may not be known at script creation time. The QV statements “SQLTables” and “SQLColumns” may be used to discover information about the sheets and columns ...
Read More

Using the Google Chart API inside Qlikview

I recently had a requirement to create a heat map of the US States and set about exploring if there was an easier way than creating a QV scatter plot mapped over an image. I found the Google Chart API. With some help from the QlikCommunity forum, I got a ...
Read More

Memory sizes for data types

An earlier post of mine When less data means more RAM discussed the ways in which storage (“Symbol” space) needed for field values can increase depending on how a field is loaded or manipulated. This generated some followup questions on the QlikCommunity forum about the optimal storage sizes for fields ...
Read More

Recipes for Qlikview Success