July 11, 2023

Q-Tip #26 – Do We Still Need to Know Set Analysis?

Hello my dear readers, aka Qlik addicts geeks who prefer reading my ramblings about Qlik over sharing funny cat memes on Facebook! Today, I’d like to talk about a (somewhat) new feature that allows Qlik Sense users (the cool kids that can author their own measures and expressions) to insert Set Analysis conditions automatically, without […]
December 19, 2022

Q-Tip #25 – Fields On The Fly (But Will They?)

Hello, and welcome back to the Q-Tips Blog! Our two wonderful Masters Summit events are over, and I’m back to share some of the new nuggets of cool stuff that I learned and discovered in my conversations with colleagues and with our students. What I love about our live Masters Summit events is the unique […]
October 27, 2022

Q-Tip #24 – The ONLY Solution, or the Subtle Difference Between Simple and Advanced Search in Set Analysis

Like many of my discoveries, this article was inspired by a Qlik Community conversation that followed an old, but still brilliant blog post by Henric Cronström, which describes the “Expression Search”. In one of the comments, a curious guy named Daniel asked a question, which led all of us to this interesting realization. First, let’s […]
October 7, 2022

Q-Tip #23 Outer Sets – To Set Or Not To Set?

I must be the last person on Earth to blog about Outer Sets, a new syntax in Qlik expressions that was added in recent editions of the tools. After two wonderful blog articles by HIC and Rob Wunderlich, what’s there to talk about? Let’s see if we can uncover some hidden treasures anyway. So, what […]
February 9, 2022

Q-Tip #22 – Improve your Wordle game with Qlik Sense

Welcome back to Qlik Sense Q-Tips, it’s been a while… If reading technical blogs is your idea of fun, then you have likely heard about Wordle, and you probably cherish your impeccable winning streak. Just in case you’ve been living under a rock, here is a quick rundown… Once a day the Gods of Wordle […]
November 19, 2019

Q-Tip #21 – AUTONUMBER, so old, so new!

Hi there! Long time no talk… As you can imagine, I’ve been busy – Master Summits for Qlik, my own “QlikView Your Business” master classes, etc etc etc… Plus, it’s not too often that we see something so interesting and so exciting that warrant a blog article. Maybe I’m not looking hard enough… Anyway, speaking […]
March 18, 2019

Q-Tip #20 – Showing All Values in Qlik Sense

Those of us old enough to have used QlikView will remember a feature that allows showing all dimension values in a chart, even if there were zeroes or no data for those values. In Qlik Sense, unfortunately, there is no such feature. After a bit of tinkering, though, I found a solution for this. And […]
January 21, 2019

Q-Tip # 19 – Insights, Anyone?

Artificial Intelligence, Machine Learning – these buzzwords are now all over the press, the Internet and social media. In the process of outsourcing everything possible, we are now actively outsourcing human intelligence, replacing it with machines. Oh wait, that sounded wrong. Perhaps we are just trying to make our work easier and more productive, constantly […]
December 17, 2018

Q-Tip #18 – Variables, Master Items, and The Little Things That Make Us Smile

If you’re like me, you probably manage your expressions in variables that you store in an external variables table rather than defining them directly in the Data Load Editor. This allows for all your variables to be easily accessible in one place, so you can always review and edit them. Variables still play an important […]
Buy now