Category: QlikView

  • Command line statement from QV Publisher

    Steve Dark has recently created askQV.com where you can search several QlikView blogs and the QlikCommunity.  It’s a great resource and I congratulate Steve for his initiative. It’s not uncommon that I found a solution to a problem only to forget it and then not know where to find it again when I need it…

  • Quick Set Analysis Tip – Selecting Current Selections

    Wow! I think it’s about time to post something new since the post about Packt has been the latest post for two months now.  I’ve been quite busy lately trying to launch new initiatives in the company and I’ve recently decided to write a follow-up book about more advanced QlikView data visualization and analysis.  If you have any…

  • Great Opportunity to Stock Up on Qlik Books from Packt Publishing

    Packt Publishing is celebrating its 2000th title, so if you were waiting for a reason to buy all those Qlik books from Packt Publishing, here’s a great opportunity to buy one and get another one free. Of course, there’s my book Learning QlikView Data Visualization and I’m going to take this opportunity to buy QlikView Server and…

  • Advanced Functions – Exhaustive DSO using dollar-sign expansion with parameters

    As everybody probably knows by now, the book “QlikView 11 for Developers” by MIguel Garcia and Barry Harmsen is an excellent resource.  Other than the cover photo and the title that could lead someone to think developing Qlik involves hardcore programming; and the space wasted on showing the pie, grid, and funnel chart, I enjoyed…

  • Set Analysis – New and Lost Customers with Nested Advanced Search

    I love the analysis that can be done using Qlik’s Set Analysis, but its syntax leaves too many business users lost and confused.  Those same business users that use Excel today for their analytical needs and aren’t completely convinced that Qlik is accessible enough to perform their own custom analysis. I believe that one day…

  • Advanced Scripting – Creating an e-mailing list in Qlik

    Recently, I set upon creating an e-mail list for a bi-monthly newsletter that my company Evolcon is going to send with updates on everythings related to Qlik and becoming a more data-driven organization.  Of course, I used Qlik to parse and clean the e-mail list, and in the process, I used some not so common…

  • Thoughts on being a Qlik Luminary

    Life is made up of moments, and I remember clearly the moment I asked by former boss for a career change. Eight years ago I decided to leave a future of implementing ERPs and bet on a new future helping people analyze their data with a software called QlikView. In 2006, QlikView was new to…

  • Is AutoNumber() really worth the hassle?

    AutoNumber() can be a pain when trying to debug problems in a QV data model, especially if you are integrating multiple data sources and need the original source’s keys to trace problems. Sometimes I get the impression that people recommend it based on the idea it will make the links between tables more efficient because…