Two questions from business users that will probably sound familiar to most QlikView Developers:
“We currently use this report. Can you re-make this in QlikView?”
and
“Our graphics designer came up with this dashboard. Can you do that in QlikView?”
Quite often you’ll find the answer to be yes. Although admittedly, you often may also want to suggest another approach, especially when asked the first question.
Recently I was asked if the following chart could be built in QlikView:
As you can see, this chart compares relative-to-total amounts for two periods. There is a vague area that connects both bars and kind-of-but-not-so-much shows the change between the periods. I had to think a bit harder before responding to that question…
read more »
One of the reasons I started this blog in 2010 was not only to share what I know about QlikView, but also to expand my own knowledge and understanding of it. In my opinion, explaining concepts and solutions to others is a great way to identify areas of improvement for yourself.
Recently, I got a new colleague at my company; Wesley Smit. Wesley is a recent graduate of Business Economics and Organization Sciences from the VU University in the Netherlands. With this business-oriented background, Wesley has an excellent understanding of the what and why of Business Intelligence. Since joining Bitmetric as a Junior Business Intelligence Consultant, we’ve been bringing him up to speed on how to develop BI solutions. Of course, the main focus is on QlikView, but we’re also working on peripheral solutions, methods and techniques that will make him an all-round consultant.
Wesley has been making great progress and is ready for the next step, not just gaining knowledge but also sharing it. In the coming time he will be posting articles on some of the things he has discovered while learning QlikView.
I welcome Wesley as a co-author on this blog and hope that you will enjoy his articles!
Today I read a very interesting blog post about the QlikView Cache by Qlik’s Henric Cronström (HIC). In the post, Henric gives a high level overview of how caching is used within QlikView to speed up front-end response times. (for a more in-depth explanation, have a look at the patent) Henric also explains some interesting peculiarities about caching, one of which busts a myth that I hear repeated very often (“running macros clears the cache”). I highly encourage you to read Henric’s post.
Of course, this post isn’t just a me-too article. Rather, I want to show you a neat thing that will let you experience the power of caching in QlikView for yourself. Did you know that you can actually turn off caching?
read more »
