Welcome to my new blog!
My name is Sandro Krumbein and I would like to use this platform to help bridge several information gaps that have been bothering me while working with QlikView. A QlikView developer is continually confronted with the following two questions:
- How do I achieve functionality x?
- What is the best way to make functionality x available?
With this blog, I want to help you find the fasted approach. Sometimes, one solution is clearly preferable to another, but in some situations, differences are not that apparent, or the best approach depends on many other factors. Finding the “optimal” solution is thus not always easy. Establishing universally-applicable rules is often difficult. Of course, you have to consider if optimization is even worth the effort. For example, if we are dealing with only 10,000 records, often any solution will do. However, when we are dealing with 10,000,000 records, things might look a little different.
For your future decision-making, you will find information presented here that will help in the search for an appropriate solution by providing you with a better sense of the results certain design decisions can achieve.
The blog should shed light on questions such as:
- is it better to use applymap or stay with inner join?
- preceding load at any cost to keep the code uncluttered, or is it better to duplicate certain parts but thereby increase performance?
- is a join using a numeric field faster than using a text field?
- what about when a field contains more/less distinct values?
If the answers to these types of questions are of interest to you, subscribe to the RSS Feed or visit regularly. I am always happy to receive questions, constructive criticism, ideas, or suggestions regarding what questions need answering for you. You can use the comment section of a post, or send an e-mail to email@example.com.