A poor man’s Slope Graph in QlikView Added By Shilpan On Monday, May 29th, 2017 at 4:25 am Dr. Edward Tufte introduced Slope Graph in his book The Visual Display of Quantitative Information in 1983. As Dr Tufte pointed out in his book, The chart, when read vertically, ranks 15 countries by  government tax collections in 1970 and 1979 with name and  proportion to the percentages. Shows how numbers changed between 1970 and 1979 […] READ MORE →

When Not to Use AGGR() Function Added By Shilpan On Sunday, April 30th, 2017 at 5:50 am   Aggr() is a very powerful, advanced aggregation function. You can’t create an expression with nested aggregations without using Aggr() function. It is a chart function which is akin to Group by clause used in a SQL statement. Back to Basics: When you use aggr() function, it involves an inner and outer aggregations:  1.  Inner […] READ MORE →

Optimize Your QlikView App Using Document Analyzer Added By Shilpan On Sunday, March 12th, 2017 at 3:15 am I am a big fan of Rob Wunderlich’s document Analyzer tool. If you are a QlikView developer or work for QlikView Center of Excellence(COE) and have application certification and code review process prior to migrating a QlikView application in Prod, this tool is invaluable. So, in this short article, I want to go over how […] READ MORE →

The Best of 2016 Qlik Blog Posts Added By Shilpan On Saturday, February 11th, 2017 at 10:21 pm 2016 was a remarkable year for Qlik. Toma Bravo acquired Qlik in June of 2016 and Qlik Sense kept making rapid strides by adding new features through out the year. That said, if you were busy building Qlik solutions and missed Qlik wisdom by visiting ever-growing list of blogs on AskQV.com, let not your heart be […] READ MORE →

Qlik Dev Group: Atlanta Added By Shilpan On Saturday, January 28th, 2017 at 8:15 pm Qlik has established itself as a leading Business discovery tool and has seen a healthy growth in the recent years in Americas. I have enjoyed Qonnections in the past as Qlik does a fantastic job of hosting such a major event every year in May. If you are a Qlik developer or a business user, […] READ MORE →