202013Aug

Q-Tip #5 – Show Top Performers. Common But Not Too Trivial.

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…

Read More
132013Aug

Q-Tip #4 – How to use “As of Date” table

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…

Read More
52013Aug
Natural Synergies’ Oleg Troyansky reviews “QlikView for Developers Cookbook”

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…

Read More
52013Jul

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…

Read More
252013Jun

Q-Tip #1 – Beware of DISTINCT!

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…

Read More
102013Jun

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…

Read More