Blog

Using the Evaluate API in Macros

A common application of QV macros is to make initial selections. These selections may be applied when the document is opened, a sheet is activated or a button is pressed. The selections usually involve some type of dynamic value, such as “today()”.In the examples below, the VBS continuation character “_” ...
Read More

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

Recipes for Qlikview Success