And-Mode in QlikView Added By Shilpan On Wednesday, May 28th, 2014 at 1:27 am And-mode in list boxes reminds me of one of my favorite characters — Sherlock Holmes. It sounds esoteric but, believe me, it plays an important role in the world of data discovery. When user makes multiple selection within a list box, QlikView engine interprets that as logical OR. In other words, all the related fields […] READ MORE →

IntervalMatch Function and Slowly Changing Dimensions Added By Shilpan On Monday, April 7th, 2014 at 1:52 am     An integral part of a dimensional model is the need to manage descriptive changes in various dimensions such as Employee. Employees frequently change jobs within a company. Often, a new job is in a different department, so it is inevitable that the company finds a way to handle this slowly changing dimension for […] READ MORE →

Powerful Pick Function in QlikView Added By Shilpan On Sunday, March 16th, 2014 at 5:12 am Simplicity is the ultimate sophistication. — Leonardo da Vinci QlikView Pick function ought to be in your toolbox if you believe in the wisdom of Leanardo da Vinci. Indeed, Pick function in QlikView simplifies your life as a developers and others who have to live with your legacy code after you decide to embark on […] READ MORE →

The Conditional Show in QlikView Added By Shilpan On Thursday, February 13th, 2014 at 5:34 am     Have you ever wondered how to design a QlikView document that requires end-users(sorry Donald Farmer ;=)) to select a value from the list box before showing a chart object with details? You are not alone! In this article, I want to share a simple tip to show or hide an object such as […] READ MORE →

Learning QlikView Data Visualization Added By Shilpan On Sunday, January 26th, 2014 at 8:09 am Have you seen 3-D pie charts lately? We all have. While the lighting effects make them look pretty, the flash and dazzle hardly improve the core function of data visualization: to convey a clear meaning to the decision makers. Data visualization is a double-edged sword. It is one of the most powerful ways to transcend […] READ MORE →