Category Archives: General

Qlik Dev Group SF June 28

Join us at the free QDG event in SF on June 28 from 5:30pm to 8:30pm.  The easy to access location is 44 Montgomery, same building as Montgomery BART.

We’ve got a great lineup in store with David Freriks of Qlik talking about the latest big data strategies, Patrick Vinton  of QlikMaps showing off some innovative GeoSpatial analytics, as well as community presenters Gerry Castellino and Rob Wunderlich covering data heirarchies and automated testing. The full program can be viewed here.

Have you been to a Qlik Dev Group meetup yet?   The meetings are free, volunteer run and take place all over the world.  At QDG diverse speakers from Qlik and the greater community give technical presentations on topics of interest to Qlik Developers.

It’s a place to share technology, practices and tips in a non-competitive, no-selling environment.

If you can join us in SF on June 28, please pre-register here. If you are not in the SF Bay Area, check the QDG site  to find a group in your region.

Hope to see you on June 28!



Yoke Dashboard

I was chatting with a colleague recently about trends in BI and I brought up what I call the “commoditization of metrics” .  Google Analytics is an early example of this — your data crunched and delivered at the KPI level.

I recently ran across a great example of the commodity metrics idea:

Yoke let’s you build your own dashboard using metrics gleaned from cloud services such as Gmail, Twitter and Github. Here’s a portion of my Yoke dashboard. It’s all built with a few clicks and no coding.

Yoke Image

Give a try, it’s free!


Join me at the upcoming “Masters Summit for Qlik” in Milan on 5-7 April. In addition to learning about all things Qlik, we’ll be talking about trends in Dashboarding and BI. 


Preparing for QlikView Version 12

There are a number of reasons you may want to upgrade to QV12, I’ll be posting about them in the next few weeks. Today’s post is specifically about what you must address to upgrade to QV12.

There are two items I’m aware of that you must be aware of and consider before upgrading.

  1. QlikView version 12 Server changes the default permission for the  EXECUTE script statement More details in this post.
  2. In QlikView 12, QVD functions now respect the DIRECTORY statement. This is a breaking change that may cause some of your QV11 script to return incorrect results or take incorrect conditional actions. More information in a post here.

So again, I’ll be blogging about new features you may want to take advantage of,  but above are the only two items I know of that you must consider before upgrading.

How do you know if you are using the impacted EXECUTE statement or QVD* functions? Perhaps you already have a tool in place to answer that question. But if you don’t, my colleagues at the Masters Summit for Qlik are making the Script Repository Tool (“ScriptRepo”) available for public download.

If you have attended a Masters Summit, then you already have a copy of ScriptRepo  in your takeaways.  if not, we would love to have you attend a Summit. But the Masters Summit Team understands the universal need for a tool like ScriptRepo whether you can attend the Summit or not.

The “ScriptRepo” tool extracts script from a directory of QVWs and then allows you to do a global search for script of interest such as “Execute”. Plug in the directory path that contains qvw files,  and a temporary work directory to extract the script into:


Press the “Extract & Reload” button and each QVW file in the input directory will be opened and the script extracted. The open is done with “nodata”, so the extraction runs relatively fast — about one qvw per second.

After extraction, you can use your favorite search tool to scan the output directory, or use the builtin QlikView search & display from the “Script Search” sheet.

After searching for “customer” and selecting a candidate qvw:



I hope to see you at the Milan Summit in April 2016 or a USA location in Fall 2016.  If you have questions about the Summit or using the ScriptRepo tool, let us know through the QlikView Cookbook Contact form or the Masters Summit Contact page.



Masters Summit 2016 — Milan

The Masters Summit for Qlik begins it’s fourth year with a date in Milan, Italy on 5-7 April. The Masters Summit is three days of advanced training designed to take your Qlik skills to the next level.

Designed for Qlik Developers who have basic skills and experience,  the Summit presents three days of intense hands-on sessions in topics such as Advanced Scripting and Data Modeling, Advanced Aggregation and Set Analysis, and Visualization Techniques.

We’ve updated our name to “Masters Summit for Qlik” to reflect that the conference now provides training and content for both QlikView and Qlik Sense.

You have some experience with Qlik, have taken the beginning courses. How do you ramp up to create more success with Qlik? Learn from seasoned experts and world class presenters Rob Wunderlich, Barry Harmsen, Oleg Troyansky and Bill Lay.

In addition to the hands-on exercises, you’ll come away with many valuable sample files and documents. You’ll also get a chance to meet and network with Qlik Developers from around the world.

In three years over 500 Qlik Developers have attended eight Summits in Europe and the US. Their feedback is overwhelming positive. Read about their experience here.

The US Summit date is in the planning stages. We anticipate the date will be sometime in September 2016.  Also stay tuned for an announcement of a brand new continent for the Summit in fall of 2016.

An early bird discount is available for Milan so register now.


Masters Summit Guest Speakers

Qlik won’t be holding a user conference in 2015. Why not spend your training time with us at the Masters Summit for QlikView in New York or Copenhagen this fall? In three days of intense hands on training you’ll take your skills to the next level and come home with the knowledge and tools to advance your company’s QlikView program and resolve those knotty problems.

In addition to advanced training from QV experts on scripting, set analysis & aggregation, data modeling, visualization and performance, we are pleased to announce some excellent guest presentations.

Christof Schwarz, Senior Solution Architect at Qlik Austria, will join us in Copenhagen with his bag of tricks for both QlikView and Qlik Sense. Christof’s presentation at the 2014 Amsterdam Summit impressed everyone with his elegant solutions to difficult visualization challenges.

Shima Auzins, former head of the Visualizations and Demo team at Qlik, now with Infozone, will share her rich knowledge in New York City by presenting  some Dashboard Visualization and Design tips that promise to be enlightening.

I hope you can join us at one of the Summits. We get incredibly positive feedback from attendees and continue to collaborate afterwards in a private LinkedIn group.  Register by July 30 to receive a $300 discount!



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”.