Oleg Troyansky

September 23, 2013

Q-Tip #7 – Execute a Command Using EXECUTE

Author: Oscar Ortiz, Senior Consultant at Natural Synergies, Inc. and QlikView professional since 2003. Have you ever been in a situation where you needed to run a batch file after running a task in publisher?  Most of the time you would create a supporting task running an external program to take care of your situation […]
September 1, 2013

Q-Tip #6 – Those Tricky $-Sign Expansions

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

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 […]
August 13, 2013

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

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

Q-Tip #6 – Those Tricky $-Sign Expansions

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

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 […]
August 13, 2013

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

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 […]
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