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…
Color Confusion
For this post I’ll be talking about something that isn’t really a Qlik issue, but I initially thought it was. Recently, I was making changes to some apps to standardize the colors that were used in charts and tables. We decided upon standards for each color and changes were made…
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…
Qonnections 2019 – The Highlights
I’ve returned from the 2019 Qlik Qonnections conference and now that I’m almost caught up, I’ll reflect on some of the major highlights from my perspective. When I wrote about Qonnections last year, I highlighted some of the major enhancements and some of the forthcoming tools and technologies that Qlik…
Drop All Unneeded Tables In An App
In this post, I’d like to share a technique for managing tables that I’ve used in both QlikView and Qlik Sense apps. Very often you’ll have an app that contains data that you binary load into one or more apps. Depending upon the number of tables and size of the…
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…