For those of us who are passionate about enhancing our knowledge of QlikView, we owe a great deal to the QlikView community and selfless QlikView bloggers.

I thought of starting a new year with collection of articles — that I considered best of the breed — from the past year. So, without further ado, I present these articles to help you make awesome in Qlikview.

• In my role as an enablement manager at QlikTech I am often asked the question, what makes QlikView Unique? Sometimes you reel off a lot of features like in-Memory, associative search and HTML 5 architecture. But is that truly what makes us Unique?  — by John Sands via Business Discovery Blog

• Do you belong to the group of people who think that Count(distinct…) in a chart is a slow, single-threaded operation that should be avoided? If so, I can tell you that you are wrong. — by Henric via Qlikview Design Blog

•  In 1973 English statistician Francis Anscombe published the paper Graphs in Statistical Analysis to stress the importance of data visualization. He wanted to show that graphs are essential to good statistical analysis.  — by Michael Anthony via Qlikview Design Blog

• “Which products contribute to the first 80% of our turnover?”  Further, here the question was about turnover, but it can just as well be number of support cases, or number of defect deliveries, etc. It can in principle be any additive measure. It is called Pareto analysis. Sometimes also known as 80/20 analysis or ABC analysis. — by Henric via Qlikview Design Blog

• Can we make “or” selections between list boxes, instead of the standard “and” selections? The question was if we could override the selection mode between list boxes. In other words, if we could return a result that showed all records associated with either Product 2 or Salesman 1. — by Barry Harmsen via Qlikfix.com

• This is first part on QlikView Joins. In this part, I have covered introduction to Joins and in future parts I will deep dive and explain them with practical examples. — by Deepak Vadithala via Qlikshare.com

• The headline grabbing fact here is that optimised QVD loads are up to 100 times quicker than non-optimised ones.  That makes a lot of difference if you are watching a reload dialog, it even makes a lot of difference to your server performance if your reload is running on a schedule. — by Steve Dark via QlikIntelligence.co.uk

• A much faster method is to aggregate the max value for the Delta rows only and then save that value on the first row of the QVD. In subsequent delta loads, only the first row of the QVD is read to get the value. — by Rob Wunderlich via Qlikviewnotes.blogpost.com

• I use ApplyMap all the time in QlikView scripts.  It is one of the best ways of getting data from a lookup table – especially with the facility to specify a default value. — by Stephen Redmond via Qliktips.com

• Few researchers bother to mention that the study by Spence and Lewandowsky robbed bar graphs of their quantitative scales. Perhaps, because pie charts lack quantitative scales, Spence and Lewandowsky felt that scales should be removed from the bar graphs to even the playing field. — by Stephen Few via Perceptualedge.com

2013 has been an amazing year and I count on 2014 to be the same. With growing Qlikview community and bloggers alike, you can become awesome in Qlikview with passion and perseverance.

Have you found awesome Qlikview articles that you can share? If so, please share your best picks in the comment. Happy New Year!!

photo by: MKD Portfolio