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 […]
February 8, 2018

News: Natural Synergies is partnering up with Analytics 10

Natural Synergies, Inc., a North American BI consulting firm, is proud to announce its new partnership with Chilean BI firm Analytics10. Analytics10 is one of the leading BI consulting companies that focuses on the Qlik® platform and delivers Qlik® Business Intelligence solutions in Chile, Brazil, Mexico, and across Latin America. Analytics10 Academy provides specialized training […]
May 9, 2017

Q-Tip #17 – The Curious Case of a Wildcard Load and a Join

It’s been a while since I had a chance to write a blog article… I can’t complain though, because preparing and delivering the Masters Summit for Qlik in Munich was a lot of fun. I also took a few days off and jumped to Prague, which was awesome! Interesting discovery (at least to myself) – in Prague, […]
December 20, 2016

Q-Tip #16 – What’s Special About Those Derived Fields

Ever since the introduction of Derived Fields in Qlik Sense, I was curious – what’s so special about them? Are they different from any other fields that are stored in your data set? Are they stored or calculated on the fly? Do they work equally well in Chart dimensions, in Filters, and in Set Analysis […]
October 27, 2016

Q-Tip #15 – Excluding the Excluded

It’s been a while since I found an interesting topic, worthy of a blog article… This Q-Tip originated from a question that we received at the Masters Summit for Qlik in Ausitn, TX. Here is the question:   Hmm… at first I was puzzled and couldn’t even come up with a direction for the possible […]
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