Category Archives: General

Nprinting & Qlik Sense Sessions Added to SF Masters Summit

We’re pleased to announce that new sessions on Qlik Sense and NPrinting have been added to Day 3 of the May 4-6 Masters Summit for QlikView in San Francisco.

Vizubi, the creators of NPrinting, have been enthusiastic sponsors of past Masters Summits. In February 2015 Qlik acquired the NPrinting product. On day 3 of the SF Summit, Andrew Porsley of Qlik will provide a technical overview of NPrinting.

  • Design and Create NPrinting Reports
    • Set up data connections
    • Create Excel reports
    • Design PowerPoint reports
    • Emailed reports
  • Delivery & Distribution
    • Schedule and deliver NPrinting documents
    • Set up report recipients, report filters and conditions
    • Deliver reports based on jobs, tasks and schedules
    • On-Demand Report Delivery
  • Administration
    • Architecture
    • Server Settings
    • Monitoring

We’ve also added a Qlik Sense session titled “Qlik Sense for QlikView Customers”. Topics will include:

  • Leveraging existing QlikView assets in Sense.
  • Coexistence.
  • Mashups.
  • Extensions.
  • Opportunities for Sense.
  • Migration tips and tools.

Hope to see you at the SF Summit! Seats are still available,




Qlik Luminary Program

TLDR: Shameless self promotion and extensive use of links.

The Qlik Luminary Program “brings together the best and brightest customers, partners and enthusiasts in the Qlik ecosystem”. Being selected as a Luminary is an honor that acknowledges a significant contribution to the community of Qlik practitioners and customers.

The point of my post today is that all four presenters at the Masters Summit for Qlikview were selected as Qlik Luminaries in 2014.  What are the odds of that! I expect that one of my colleagues or a QlikCommunity member will post the applicable probability expression — written in QlikView syntax of course. Followed up by a gentle refinement by Henric Cronström — who was a special guest at our 2013 London Summit.  At that very  same summit Henric not only took us back in time to a QlikView 0.9 demo but also busted the count distinct myth.

Speaking of the London Summit, Steve Dark, another 2014 Luminary,  contributed valuable experiences during the general sessions and followed up with detailed posts in his blog on questions raised during the summit.

While the 2015 Luminary class has not been officially announced, I expect a least a couple of us will repeat as Luminaries. If we don’t all make it, I’ll chalk that off to a  smaller class rather than anyone slacking off.

Stephen Redmond has announced that he is a member of the 2015 Luminary class.  Stephen certainly deserves the honor, having written several excellent and well regarded books on QilkView. Stephen graced us as the guest speaker in the aforementioned London Summit.

Speaking of Summit memories, I have fond recollections of the Barcelona Summit. I forgot to pack my trademark hat. Frank Buender of Lynxx BV bought me a substitute hat during our evening social time. Frank also posited many challenging and provocative questions to the Masters  and went on to contribute in the private LinkedIn group for Summit attendees.

At each Summit, we have a carefully selected guest speaker.  In Amsterdam, Christof Schwarz of Qlik wowed the audience with his innovative tips and solutions.

I hope to see you at one of the 2015 Masters Summit for Qlikview.  I anticipate we’ll see a number of QlikView Luminaries.  I expect we will push the boundaries of QlikView, and  of course, now Qlik Sense.




SF Masters Summit Early Bird Discount ends Feb 27

SFBannerThe bird is in this photo is not a seagull. She’s an earlybird, headed to to take advantage of the earlybird registration discount available until February 27.

At the Summit, birds of the Qlikview Developer variety will be immersed in three days of hands-on advanced and intermediate QlikView Developer training. We’ll be covering topics such as advanced scripting, advanced expressions & aggregation, visualization, data modeling, performance, server administration and Qlik Sense for QlikView  customers.

Training will be led by four popular instructors, all well known as Consultants, Bloggers, Qlik Luminaries and longtime QlikCommunity contributors.

Barry Harmsen: Co-author of the seminal book “QlikView 11 for Developers” and founder of the Q-on Training Center.

Oleg Troyansky:  Author of the upcoming “QlikView Your Business” , QlikView veteran and one of the all time top contributors to QlikCommunity.

Rob Wunderlich (hey that’s me!):  Publisher of and founder of the QlikView Components open source script library.

Bill Lay: Visualization wizard and everyone’s favorite presenter. Bill’s entertaining  presentation style makes any topic interesting and engaging.

In addition to the class material, we’ll have an evening panel discussion, guest speakers and plenty of opportunities to network with peers.

Read more about the Masters Summit for Qlikview and Register here.  See you in San Francisco!



Qlik Sense Opportunity for QlikView Customers

I had a great time participating in the Hackathon at the recent Qlik World Conference in Orlando. The Hackathon challenge was to create a visualization solution to a United Nations challenge using the Qik Sense Mashup APIs. It was a stimulating exercise for a number of reasons — the subject matter, the company of talented practitioners, and the Sense API ease of use and powerful functionality.

Through my experience with using the APIs and talking with a number of customers at the conference, I see a clear opportunity for existing QlikView customers to leverage Sense as an Extranet or Mashup solution.

Many QlikView customers have apps that currently deliver great value inside the company. These apps may be mature, data dense and backed by a sophisticated data model. Everyone is happy, but there may be some discussion about providing a subset of the solution to external users like B2B customers over the web.   That has been  possible with QlikView, but it can be to be complex to implement. It’s much easier with Sense and I think Sense could be the killer solution for extranet reuse. Here’s why:

  • The existing QlikView data model can be reused by Sense with a simple Binary Load. No need to write additional script and you maintain a single-version-of-truth for both internal and external users.
  • The sense charts and visualizations are much more “webby” in appearance and behavior,  meeting the modern expectations of web users and web developers alike.
  • The APIs are powerful, clearly designed and will be easily understood by web developers tasked with integrating Qlik content and data into portals or other  interface.
  • Better APIs to get data from the Qlik engine. For example, there are methods to create and return “hypercubes” of data. Pass in Dimensions and Expressions and calculated data is returned — without the need to create a chart. The returned data can be visualized or used to drive another process.
  • The new Session Authentication API can delegate user authentication to an existing portal session, eliminating the need for a piggybacking WebTicketing exchange. This satisfies the common customer requirement that “when the portal session ends, the Qlik session should end”.




Masters Summit for QlikView Europe: Amsterdam October 2014

After successful events in Las VegasLondon and Barcelona, and the upcoming event in Chicago next April 1 – 3, I am pleased to announce that the next European edition of the Masters Summit for QlikView will be held in Amsterdam, The Netherlands on October 1 – 3, 2014.
If you are a QlikView developer then the practical skills, ready-to-use resources and excellent peer networking offered at this event will make for 3 days that you do not want to miss! More information about the event can be found on the Masters Summit for QlikView website. Information about the venue will be added soon.
If you are based in North America or can’t wait until October, there are still seats available at the Chicago summit April 1-3. Registration is available on the website.

Qlikview Cookbook Online

My “Qlikview Cookbook” is now available online at where you can browse and download high-quality examples and tutorials.

In 2008 I published the first edition of the “Qlikview Cookbook”, a downloadable collection of Qlikview examples designed as a reference and training tool for Qlikview developers. The last update to the Cookbook was in 2011 and  it has been downloaded from over 20,000 times.
You can follow updates to the Cookbook in a couple of ways:
1. Sign up for the Cookbook Newsletter on the Qlikview Cookbook home page. You’ll receive a monthly email of “What’s New” plus bonus material. 

2. Follow @QvCookbook on twitter.

Use the site’s contact form to leave me any suggestions or requested additions. 

Happy learning!

Note: The QlikviewCookbok site is not related to the similarly named and excellent book “Qlikview Cookbook for Developers” by Stephen Redmond. 

Masters Summit for Qlikview — Chicago April 1-3

Masters Summit for Qlikview

The next  Masters Summit for Qlikview is approaching. Dates are April 1-3 and the location this year is Chicago.

I’ll be joining some of the leading QlikCommunity contributors and authors live for 3 days  to discuss advanced techniques in building complex solutions with QlikView.
Sessions are targeted at intermediate to advanced Qlikview developers and will cover advanced tools and techniques across a wide spectrum of Qlikview development skills — Scripting, Modeling, Visualization, Expressions, Server, Performance. See the list of sessions here.
In 2013 Masters Summits were held in Las Vegas, London and Barcelona. Response from the attendees was overwhelmingly positive. Read their comments here.
For complete program details and registration information, see the Summit Website. I hope to see you there!

Using Alerts to “Send the Numbers”

The Qlikview Document Alert feature is generally thought of as a way to notify users or administrators of exceptional conditions in the loaded data. But it may also be used for regular emailing of non-exception conditions, like daily sales figures. This can be very useful to inform mobile or travelling user of the status of Key Performance Indicators.

The Document Alert feature is part of basic Qlikview. No additional software or license is required. Please note that that Alerts can only send out text email. They cannot send graphical charts or attachments. If you want that  functionality, look to third party addons such as NPrinting.

Alerts are configured in a QVW using the menu item: Tools, Alerts. The Alert Message may contain dynamic (calculated) content in the form of an expression like:

=’Sales YTD:  ‘ & money(sum({<Year={$(=year(max(OrderDate)))}>}OrderAmount))

I won’t go deep into the configuration details here, because I’ve provided a downloadable annotated example at this link:
Qlikview Cookbook: Using Alerts To Send Numbers Via Email 

The example will produce an email after reload that looks like this:

Alerts are a low cost and simple way to expand the reach and value of your QV applications. Users receiving emails do not require a Qlikview license.


Related posts on Alerts: