Oleg Troyansky
September 1, 2013
This blog post was inspired by an excellent lecture on Advanced Scripting that Rob Wunderlich is delivering at the Masters Summit for QlikView – the only deep-down technical event for advanced QlikView developers. Please check out our upcoming events in Europe. … The longer I work with QlikView, the more fascinated I get with its […]
August 20, 2013
This material is going to be a part of my presentation on Advanced Set Analysis and Advanced Aggregation at the Master Summit for QlikView, which is coming up in October in London and Barcelona. During my 4-hours “deep-dive” session, we analyze complex business requirements and learn how to solve them using Advanced Set Analysis and […]
August 13, 2013
This need comes up a lot in the questions that people ask on the forum… Imagine that you are working with Sales data, presented monthly, and you need to build a chart that shows monthly sales, and next to it, average sales for the last 6 months. How would you calculate average sales for the […]
August 5, 2013
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
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
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 25, 2013
We all know and use QlikView keyword DISTINCT, which makes the resulting table of the load unique. What we don’t usually know, until we learn it the hard way, is that DISTINCT can be very dangerous and deceiving. We will mention two major issues with DISTINCT that are not too obvious: DISTINCT doesn’t always mean […]
June 10, 2013
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 […]