92 articles in this selection
| 2013/04/25 QlikView 11 for Developers
QlikView 11 for Developers book page. Includes free PDF download of a sample chapter. Unfortunately no torrent :)
| |
|
|
| 2013/03/26 What QlikView Consultants can learn from the A-Team
In today’s post, I am going to take a closer look at the skills and qualities of the A-Team, and will explain how they can be translated to the role of a QlikView Consultant. (Or, alternatively, how these roles can be used to staff the perfect QlikView Competency Center.)...
| |
|
|
| 2013/01/07 QlikView 11 for Developers, A Review
This book has everything that a new QlikView developer will need to get started. But not just that, it also has a lot of tips in there for the experienced developer (I know because I found some myself!) Even if you have a few years experience in developing QlikView, you will find nuggets of useful information in here....
| |
|
|
| 2013/01/04 QlikView 11 for Developers [Kindle Edition]
QlikView 11 for Developers is aimed at both beginning and experienced QlikView developers. The book offers a completely practical and hands-on tutorial for learning both basic and advanced QlikView development concepts and best practices. The book follows a practical case, HighCloud Airlines. This case evolves throughout the book, developing your QlikView skills step by step while gradually building a complete QlikView solution....
| |
|
|
| 2013/01/04 QlikView 11 for Developers [Paperback]
QlikView 11 for Developers is aimed at both beginning and experienced QlikView developers. The book offers a completely practical and hands-on tutorial for learning both basic and advanced QlikView development concepts and best practices. The book follows a practical case, HighCloud Airlines. This case evolves throughout the book, developing your QlikView skills step by step while gradually building a complete QlikView solution....
| |
|
|
| 2012/12/27 Posting Data from QlikView to Other Systems using the Ajax Client
There are many scenarios where it is necessary to process QlikView data with other systems. There are many approaches and examples available how this can be achieved using Macros (based on the QlikView IE-Plugin) but this article cover how you can realize such a requirement by using only the QlikView Ajax client....
| |
|
|
| 2012/12/05 QlikView Book: QlikView 11 for Developers
With over 500 pages of completely original content, QlikView 11 for Developers is aimed at both beginning and experienced QlikView developers. The book offers a completely practical and hands-on guide to learning both basic and advanced QlikView development concepts. The book follows a practical case, HighCloud Airlines. This case evolves throughout the book, gradually developing the QlikView application along with your QlikView skills....
| |
|
|
|
|
| 2012/11/26 QlikView 11 for Developers | Packt Publishing
* Learn the techniques and best practices to transform data in QlikView via script * Loading data from disparate sources to build an associative Data Model * Building robust data models and overcoming common modeling challenges * Designing data visualization objects to present performance measures with charts and tables * Learn to use dimensions and expressions in QlikView objects * Utilise QlikView’s built-in aggregation functions to achieve complex calculations * Creating Point In Time reporting and achieving complex calculations using Set Analysis * Creating a consistent and interactive user interface * Ensuring your QlikView applications and data are protected * Constructing a data architecture that supports scalable QlikView deployments * Learn time-saving techniques for making your QlikView development more efficient...
| |
|
|
| 2012/11/25 Announcing QlikView 11 for Developers: The Book
After many months of hard work, today I am proud and excited to announce the upcoming release of the new QlikView book that Mike García and I wrote together: QlikView 11 for Developers
| |
|
|
|
|
|
|
|
|
| 2012/07/24 Visual FX in QlikView
Curious to see if I could create an animated chart that, while maybe not informative, at least looks pretty, I decided to create a chart based on Lissajous curves. You can see the result, which uses a standard scatter plot, in the video below.
| |
|
|
|
|
|
|
| 2012/05/18 Any colour, as long as it’s green
Today I read the blog post “Green Is The Colour” by Henric Cronström on QlikTech’s Business Discovery Blog. In this post, Henric points to the fact that, while green may be QlikView’s signature colour, it is the unassociated, gray values that are a crucial part of the discovery process. While I completely agree with Henric that the colour coding is integral to the QlikView experience, his post did leave me wondering. Does it always have to be green?...
| |
|
|
| 2012/03/27 QlikView 11 SR1 withdrawn
I usually advise my clients not to upgrade to a new major QlikView version until the SR1 release is available. You can imagine that I was quite excited when QlikView 11 SR1 was released little over a week ago, finally could my existing QlikView customers use the cool new features of QlikView 11! Notes! Session collaboration! Document extensions!...
| |
|
|
| 2012/02/23 Crispy-clear image exports from QlikView
A short post today on an ‘annoyance’ that invariably pops up at my clients; when copy and pasting images of QlikView objects into their PowerPoint presentation or Word document, the images look blurry and slightly out of focus. Fortunately, there is an easy way to solve this....
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 2012/01/20 QlikCommunity: Cross site scripting
JS files need to be in the site root. I'm not completely sure why this is, but unfortunately that's how it is. I think image files can be accessed in subfolders (I've never tried CSS), but yeah JS files have to be in the root.
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 2011/10/31 An Agile BI Maturity Model - Forbes
To shed light on this topic we turned to Christian Chabot, CEO of Tableau, a company that has been in business of Agile BI since it was founded in 2003. We asked Chabot how he would define an Agile BI Maturity Model that reflects how people actually adopt and begin to reap value from Agile BI....
| |
|
|
|
|
| 2011/10/20 Product Comparison - Omniscope, Tableau & QlikView
Many people have asked us to provide a comparison of the three interactive visualisation tools we use - Omniscope, QlikView and Tableau; this is best served through discussion with you so that we can understand your specific needs, but the table below provides a very high-level comparison. Please bear in mind that in order to make a comparison we have had to simplify the specific capabilities of each tool; each approaches the data visualisation problem from a different angle, so each vendor could argue that our simplistic answers are unfair....
| |
|
|
| 2011/10/18 QlikView round-up: If-statements, INLINE tables and EDX
Time to dust off a posting category that hasn’t been getting as much love as it should have; the QlikView blog round-up. Today I have for you three blog posts that I read recently and found very interesting: * What a big “If” you have * Nifty trick for INLINE tables * EDX in QlikView...
| |
|
|
|
|
| 2011/10/16 Business Intelligence Adventures: What a big "If" you have
Have you ever been asked to automate a manual process? If you have then you have probably been ambushed like Little Red Riding Hood. Things start off normally enough Grandma is wearing her nightcap and her glasses or the process you are automating has rules and lists but everything is pretty normal just like Grandma. Then you notice that Grandma has very big eyes, and very big ears and a monster flow chart that defines all the exceptions to the lists and rules......
| |
|
|
|
|
|
|
|
|
|
|
|
|
| 2011/06/10 Not all QlikView variables are created equal
Starting an expression with or without an equals sign may almost seem like an arbitrary decision. Most developers quickly figure out that this is not true for text objects. However, there is another, less obvious area where the use of the equals sign can greatly impact how (and more importantly, when) your expression is calculated....
| |
|
|
| 2011/04/13 Best Practices for QlikView iPad User Interface Design
The user interface for touch screen mobile devices such as iPad is different from the UI for laptop or desktop computers in two primary ways: screen real estate and user interaction mechanism (touch screen vs. keyboard and mouse). QlikView developers should take these important differences into account when designing QlikView applications. Timed with the release of our newest QlikView on Mobile functionality in QlikView 10 service release (SR) 1, we thought we’d share with you a few best practices for designing QlikView apps that users will access via iPads. These practices come to you courtesy of Shima Nakazawa, QlikTech’s Director of Demos and Best Practices....
| |
|
|
| 2011/03/16 Excel and VBA: the poor man’s QlikView
Today I have something completely different for you. It is only tangentially related to QlikView and lacks any practical application for QlikView professionals, but I know it will make you smile when you see it.
| |
|
|
| 2011/02/24 Think About Design When Thinking of BI
For some time now, academics and business leaders have celebrated design thinking as the panacea for failing corporations and the secret of savvy managers. On January 5, 2009, a group of leaders from the professional organizations of design who call themselves “The American Design Communities” presented a document to the U.S. Congress called Redesigning America’s Future: 10 design policy proposals for the United States of America’s economic competitiveness & democratic governance. This is the first document of its kind in two decades. Indeed, design is gaining importance in every area. This discussion with Elif Tutuk, a leading industry technologist, will shed light on how design thinking could be applied to Business Intelligence....
| |
|
|
| 2011/02/20 Gwent to expand use of police intelligence tool
The software is mainly used by the force to measure staff performance, but it is now planning to use the system to keep tabs on crime rates across the county. Gwent's Qlikview developer, Paul Evans, told GGC that the tool, which pulls in data from multiple data sources and then displays relevant information to staff, will link with a geographical information system. The information that is held in Qlikview in table format will then be plotted onto a map....
| |
|
|
| 2011/02/17 Qlikview Notes: QVD Questions and Answers
On Feb 2 I presented a live webinar titled "Understanding & Best Practices with QVD Files". You can view a full 36 minute recording of the presentation or download the slides as a pdf. Many questions were submitted during the presentation, too many to answer at that time. I've tried to answer those questions and others below. If you have further questions about QVDs, post a comment here or in the QlikCommunity Forum....
| |
|
|
| 2011/02/07 Merging tables in QlikView: the JOIN prefix
This is the second post in a series on merging tables in QlikView. In the previous post I wrote about appending rows to tables by using the CONCATENATE prefix, this time I will show you how to add columns to a previously loaded table by using the JOIN prefix....
| |
|
|
| 2011/02/04 Hands-on with QlikView Script Generator
I was pleasantly surprised when I read the announcement for QlikView Script Generator (QsGen) this week. QsGen promises, amongst other things: * Visually design complex scripts to load your data * No more need of scripting skills * 500% faster design Interested to see if I really would not need any scripting skills to build fantastic “marble tracks” of data I decided to download the trial version and test it with QlikView 10 SR1....
| |
|
|
| 2011/02/04 QsGen - QlikView Visual Script Generator
With QlikView Script Generator you can start directly loading your QlikView applications without special knowledge. In a one hour online video training you will you will master the program and generate your first application. Linking table's columns are intuitive. Adding Excel sheets to your diagram is a question of drag & drop and wizards. Once your mapping schema is designed you can generate many different applications and maintain them from a central point....
| |
|
|
|
|
| 2011/01/24 Automatically create linktable & remove synthetic keys
This script automatically creates a linktable and removes synthetic keys from "any" combination of tables with common field names. Perfect in situations where you have several transaction tables (Invoices, Orders, Budget etc...), with several common field names. Simply copy - paste this script to your applications to solve these situations. The script will identify all common fields and build a data model based on a linktable automatically. Use carefully, and don't trust that it is working 100% until you have verified your data....
| |
|
|
| 2011/01/18 Getting started with QlikView
Lately I have been getting a lot of inquiries by people asking me how to get started with the Personal Edition of QlikView. It seems to be a very popular new year’s resolution this year, and one that is definitely a lot easier to keep than losing weight, getting fit or quitting smoking (hang in there everyone!). Rather than answering everyone individually, I am trying to take a more efficient approach by writing this post in which I lay out what I believe is a good path to get started with QlikView, without having to immediately draw your wallet to buy training....
| |
|
|
|
|
| 2011/01/03 A Microsoft guy does QlikView
Over the holidays, I decided to experiment with some business intelligence technology that I normally don’t have the opportunity work with – QlikTech’s QlikView. In a nutshell, I took Microsoft’s Contoso Retail sample DW, brought portions of it into QlikView, and created several dashboards....
| |
|
|
| 2010/12/28 Creating a custom sort order in QlikView: load order & dual
In a previous post I described how to create a custom sort order in QlikView by assigning a sort order value in the load script or by using the match function. This post describes two other clever methods that I recently became aware of.
| |
|
|
| 2010/12/28 QlikView Wiki
QlikView articles, best practices and solutions to problems posted by QlikCommunity members.
| |
|
|
|
|
| 2010/12/21 How I Sell QlikView
I recently spent an afternoon with the CEO and CTO of a Toronto based firm. They requested a QlikView demo and also some recommendations on how to build a strong Business Intelligence (BI) strategy. Both executives understood the value of BI and the opportunities for developing better insights into their business - it was a terrific 3 hours....
| |
|
|
|
|
| 2010/12/15 Qlik CEO Lars Bjork Sells $9.3M in Company Shares
CEO, President of Qlik Technologies Inc. (QLIK) Lars Bjork sold 423,421 shares on 12/08/2010 at an average price of $21.94. QLIK Technologies Inc. engages in developing business intelligence solutions. Qlik Technologies Inc. has a market cap of $1.82 billion; its shares were traded at around $23.4 with and P/S ratio of 11.5....
| |
|
|
|
|
|
|
| 2010/12/01 Color Mixology 101 & Heat Maps
I used a great QV feature for the first time this week – the Color Mix Wizard. Insofar as it is indeed a Wizard, there’s not a lot you need to know to use it, but I’ll walk through the steps I took…
| |
|
|
| 2010/11/25 Custom formatting table cells
A short tip today about something that actually took me quite some time to figure out: how to easily format table cells. Where in Excel you can just right-click on a cell and choose “Format Cells”, that option seems to be missing in QlikView … or is it?...
| |
|
|
| 2010/11/22 Prebuilt QlikView Script for Mozilla’s Open Data Visualization Contest
A few days ago I became aware of the Mozilla Open Data Visualization Contest that is being organized by Mozilla Labs and the Mozilla Metrics Team. The goal of this contest is to creatively visualize answers to the question “How do people use Firefox?”. For example by creating visualizations that investigate interesting usage patterns, reveal interesting user behavior, or explore browser performance. I figured this would be a nice challenge, so I decided to download the data and load it into QlikView. Since I am always curious to see what other people can do with QlikView (it can be very educational) I have shared my load script and data cloud here, so that other developers interested in joining the competition can get a running start....
| |
|
|
| 2010/11/22 The Magic of Set Analysis – Part III
In Part II of The Series, I wrote about the general syntax of a Set Expression and provided some basic examples using Set Modifiers with explicit field value definitions. Now, our next step will be about making our desired record set dynamic and based on the user’s current selections, that is, using an Implicit field value definition....
| |
|
|
|
|
| 2010/11/14 Rainy Sunday QlikView blog round-up
It’s a rainy Sunday here in the Netherlands, a good time to catch up on some reading and share with you some of the QlikView-related blog posts, articles and discussions that I found interesting in the past week.
| |
|
|
|
|
|
|
|
|
|
|
| 2010/11/01 QlikView 10 blog & resource round-up
It’s been a few weeks since QlikView 10 was released and a lot has been written in the mean time. In this post I will list the articles, blog posts and resources that I found the most useful while learning about QlikView 10′s new features and functionality....
| |
|
|
| 2010/10/30 Qlik Here for My View of QlikView 10
All in all, QlikView 10 offers some incremental improvements in important areas such as ease of use and performance. The new version is available immediately so you can download and try it yourself and get access to documentation and videos of demos and how to use it. In the future, it would be nice if you didn’t even need to download it – maybe the next version we can simply run in the cloud. Now QlikView has to continue its growth, expand its presence in the lines of business and use its new release as an opportunity to grow its market share....
| |
|
|
| 2010/10/29 A Russian QlikView user learns about Extensions in QlikView 10
A Russian QlikView user is being interviewed at Qonnections about the new visualization options in QlikView 10. He expresses his disappointment with the choice to add Mekko charts as a default chart. Is there anything that can make him happy again? Visit www.qlikfix.com for more....
| |
|
|
|
|
| 2010/10/18 GlobeQlik
Web-based geographical analysis for QlikView. Not as fancy as GeoQlik, but not as basic as Google Maps.
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 2010/09/30 QlikView GMail Viewer Gadget
Here's a handy little Add-in I developed recently for QlikView users who also use Google Apps for their email. It's a GMail Contextual Gadget which monitors for links to QlikView Ajax Dashboards in the body and subject lines of emails and, if found, displays the dashboard inline in the email allowing the user to interact with the QlikView application without even leaving their email....
| |
|
|
| 2010/09/29 QlikDecision
One of the great new features in QlikView 10 is the idea of extending the concept of the associate data model. The embedded search tool now supports the idea of Associative Search.
| |
|
|