ApplyMap Function in Qlikview Added By Shilpan On Tuesday, May 7th, 2013 at 4:39 am Mapping is a familiar concept to those of you who have dealt with ETL(Extract, Transform and Load). ApplyMap is a lookup or mapping function in Qlikview. In nutshell, it is a simple little function in Qlikview that you can get addicted with easily once you master it and keep finding creative ways to use it in […] READ MORE →

Dynamic Bookmarks in Qlikview Added By Shilpan On Thursday, May 2nd, 2013 at 3:23 am Have you heard about bookmarks even if you are not a computer geek? We all have. I am an avid reader, and I love collecting free colorful bookmarks from my local library. And I put those bookmarks to use once I start reading a new book. Bookmarks in Qlikview perform similar function. They are used […] READ MORE →

Magical Match Function in Qlikview Added By Shilpan On Saturday, April 27th, 2013 at 4:00 am Indeed, match function is a magical function when it comes to string comparison in Qlikview. For those of you who know SQL, you can use “in” operator in SQL statement to limit data set for certain matching values in a given column. For example, if I want to retrieve data set for those employees with title of […] READ MORE →

Dual Function in Qlikview Added By Shilpan On Sunday, April 21st, 2013 at 5:33 am One of many things I like about Qlikview is its simplicity. I am an ardent fan of Warren Buffett because of the simple life he lives amidst the ocean of wealth; I am an ardent fan of Qlikview for its simple data types amidst the ocean of data it explores. Qlikview stores field values as […] READ MORE →

The Power of Preceding Load Added By Shilpan On Sunday, April 14th, 2013 at 5:10 am We’ve heard the classic expression, “There are many ways to skin a cat” Well, it is so relevant when it comes to development in Qlikview. The fun part of Qlikview development is that it makes you think and, many times, you can achieve your goal in more than one ways. In this tutorial, I will […] READ MORE →