Harvesting Wisdom

Pover Consulting: a blog about data discovery

  • 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…

  • Let’s do it again! Win a Free Copy of Packt’s Learning QlikView Data Visualization.

    Packt Publishing is going to be giving away 2 free copies of Learning QlikView Data Visualization this week. Overview of Learning QlikView Data Visualization How to Participate During the last giveaway, I asked for ideas on what data visualizations you would like to add to QlikView.  Now, I can’t imagine the development team at QlikTech being able…

  • 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…

  • Congratulations to the winners!

    Thanks to all those who responded to my post in QlikCommunity and in this blog about what data visualization they would like to see in QlikView.  I learned a few things about what people would love to do in QlikView.  Most visualizations that were posted are possible to create in QlikView, but what frustrates many…

  • Win an e-book copy of Learning QlikView Data Visualization

    This week I’m giving away three e-book copies of Learning QlikView Data Visualization.  To be eligible to win all you have to do is post what data visualization method you would like to do in QlikView that you have not been able to do until now.   It could either be a chart or a technique.…

  • Pie charts or parts-to-whole analysis

    Those who have read Learning QlikView Data Visualization may wonder why I didn’t talk about pie charts in the book.  Some may even assume that I am a data visualization idealist that tries to deny people’s temptations to create pie charts, but while I do support those idealists, I have created more than a few pie charts…

  • KPI Parallel Coordinates Chart

    In chapter 4 of Learning QlikView Data Visualization, I explain how to perform multivariate analysis with heat maps and mini-charts.  However, I left out the possibility of using a parallel coordinates chart to analyze the relationship between several variables.  Honestly, this method is rarely great for communicating your discoveries to others, as Stephen Few explains so well…

  • How to combine a bar chart and a heat map

    Many times users lose a great opportunity to use color to make their QlikView interface more appealing and insightful when they choose to make a rainbow-colored bar chart.  One of the most important subjects I had to leave out of Learning QlikView Data Visualization was how to apply the coloring technique of a heat map to a bar chart.…

Got any book recommendations?

Get In Touch