Information for developers, analysts and administrators
 

Help Text Popup Extension — Add HTML Help Text To Your Application

I’ve just uploaded a new extension to Qlik Branch that I’d like to tell you about. The visualizations on most Qlik Sense pages are usually self-explanatory. Sometimes, one even the most well-designed sheets, you’ll have complex visualizations that do require explanation or possibly even a little training. The Help Text …

Using Advanced Set Analysis Operators To Power Your Visualizations

In this post, I’m going to talk about the differences between some of the set analysis operators. … Okay, I’ll agree that the world probably doesn’t need another blog post on set analysis, but I’m going to focus specifically on the four operators that I think are underused. I get …

Off the Charts. When and how to use a custom axis on a chart.

Most of the time, when you create a chart, you can leave the Range selection for the X- and Y-axes on “Auto”. Recent versions of Qlik Sense have improved the logic that’s used to determine these ranges and it’s also usually the most efficient option in terms of refresh time—and …

Interesting Behavior With The Previous() Function In a Load Script

There are many examples on the Qlik Community site that address the fundamental difference between Previous() and Peek(), but recently, I discovered an interesting behavior that I didn’t see covered in any of the articles I’d read. First, here is an example of the basic difference between the two functions. …

Qonnections 2018 – Data Literacy and Welcome Disruptions

“We do not apologize for this disruption.” Those were the words on the big screen as the first general session got underway at Qonnections 2018 and Qlik announced their Data Literacy initiative. But, why is this important? Qlik pointed out in survey results earlier this year that, “80% of the …

Using AGGR instead of IF for complex dimensions

In this post, I’ll focus on a quick tip that encourages the use of Aggr for complex dimensions. What’s a complex dimension? Most of the time, we’ll construct the database for our app so that our users can simply drag or select a field for a dimension and use it—that’s …

Configuring Your Apps Across Environments and Servers With a Keywords File

In this post, I’ll share a technique that I’ve used for many years in my QlikView scripts and recently revised for use in Qlik Sense. Most larger Qlik Sense development environments and many smaller ones follow a process before an App gets into a public (or production) stream. Usually, the …