Featured

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 […]
May 16, 2016

Q-Tip # 14 – AGGR() and Synthetic Dimensions

Hi everyone – QlikView and Qlik Sense developers, beginners and experts, those who usually ask questions on Qlik Community and those who usually answer them. Today I’d like to talk about one of the most mysterious issues of all (at least, this is how it looks like on the Qlik Community forums) – using the AGGR() […]
December 29, 2015

Q-Tip #13 Happy New Year, New Calendar Functions, and New Behaviors!

Apologies to my blog followers for a long period of silence. Needless to say, I’ve been busy – among other things, working on converting our Masters Summit for QlikView into all new, freshly re-designed Masters Summit for Qlik. The difference may sound subtle, but in reality, a lot of preparation work is happening as we speak. […]
September 15, 2015

Q-Tip #12 – Peek() or Previous() ?

This article was sparkled by this discussion thread on Qlik Community. The question was: how to calculate the difference between dates that are stored in consecutive rows of a table? Three answers to the question suggested three different approaches. Let’s analyze what’s right, what’s wrong and does it matter at all? We typically use values from […]
August 19, 2015

Q-Tip # 11 – So How Many Customers Make Up Most of Your Sales?

You obviously know the Pareto principle – 80% of outcomes are driven by 20% of efforts. QlikView offers numerous tools that allow visualizing the Pareto principle. Here are just a few that come to mind: It’s quite easy to create a Pareto report and show cumulative contribution of Customers (Suppliers, Products..) to the overall % […]
August 7, 2015

News: QlikView Your Business – the wait is over!

Great news for everybody who’s been waiting for the release of our new book, QlikView Your Business. The book is officially out. I just received my author copies. Amazon shows the book “in stock”, and as far as I know, they are shipping pre-orders now. At the time this article is being written, Amazon still […]
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 […]
May 16, 2016

Q-Tip # 14 – AGGR() and Synthetic Dimensions

Hi everyone – QlikView and Qlik Sense developers, beginners and experts, those who usually ask questions on Qlik Community and those who usually answer them. Today I’d like to talk about one of the most mysterious issues of all (at least, this is how it looks like on the Qlik Community forums) – using the AGGR() […]
December 29, 2015

Q-Tip #13 Happy New Year, New Calendar Functions, and New Behaviors!

Apologies to my blog followers for a long period of silence. Needless to say, I’ve been busy – among other things, working on converting our Masters Summit for QlikView into all new, freshly re-designed Masters Summit for Qlik. The difference may sound subtle, but in reality, a lot of preparation work is happening as we speak. […]
September 15, 2015

Q-Tip #12 – Peek() or Previous() ?

This article was sparkled by this discussion thread on Qlik Community. The question was: how to calculate the difference between dates that are stored in consecutive rows of a table? Three answers to the question suggested three different approaches. Let’s analyze what’s right, what’s wrong and does it matter at all? We typically use values from […]
August 19, 2015

Q-Tip # 11 – So How Many Customers Make Up Most of Your Sales?

You obviously know the Pareto principle – 80% of outcomes are driven by 20% of efforts. QlikView offers numerous tools that allow visualizing the Pareto principle. Here are just a few that come to mind: It’s quite easy to create a Pareto report and show cumulative contribution of Customers (Suppliers, Products..) to the overall % […]
August 7, 2015

News: QlikView Your Business – the wait is over!

Great news for everybody who’s been waiting for the release of our new book, QlikView Your Business. The book is officially out. I just received my author copies. Amazon shows the book “in stock”, and as far as I know, they are shipping pre-orders now. At the time this article is being written, Amazon still […]
Buy now