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 […]
September 26, 2013

News: Steven Jones, MBA is joining Natural Synergies as a Director, Healthcare Analytics

Natural Synergies, a leading QlikView consulting firm, is pleased to announce that Steven Jones has joined the Company as Director, Healthcare Analytics. Jones was previously the Analytics Director at Navitus Health Solutions where he was responsible for leading the Analytics team which was charged with development and implementation of all QlikView applications. As Director, Healthcare […]
August 5, 2013

Natural Synergies’ Oleg Troyansky reviews “QlikView for Developers Cookbook”

Natural Synergies, Inc.’s president, Oleg Troyansky, reviews “QlikView for Developers Cookbook”, a new book by Stephen Redmond and published by Packt Publishing. Packt Publishing continues its tradition of publishing QlikView technical books. After a very successful educational book, “QlikView 11 of Developers”, written by two extraordinary QlikView masters, Barry Harmsen and Mike Garcia, they recently […]
July 18, 2013

Q-Tip #3 – Pressing “Back” button is not just for selections

It’s fascinating how obvious things often turn out to be “not-too-obvoius”… We know that the “Back” and “Forward” buttons in QlikView can take you back to your previous selections and forward to more recent ones. So, if you made 2 consecutive selections, pressing “Back” twice should return you to the starting point? Well, most of […]
July 5, 2013

Q-Tip #2 – Those “not-so-invisible” hidden objects

So, we all know that QlikView only spends resources on calculating objects when they are visible, right? WRONG! If you have many hidden objects on a page, check out the Sheet Properties, tab Objects, and see that the hidden objects still draw substantial Calc Time, even if they remained hidden from the very beginning. We […]
June 10, 2013

Intro into Q-Tips

Q-Tips are little nuggets of knowledge that we collect on the way as we learn more about anything — QlikView, BI, systems, life… In this section, we’ll be publishing little tips and tricks, “gotcha” and “aha!” moments, warnings and bug reports. What’s in the name? Well, besides our obvious obsession with the letter “Q”, we […]
Buy now