Category Archives: General

Spring Holiday Recommendations

Summary: This post has nothing to do with Qlik. It’s a reach out to the community I have built over the years soliciting holiday recommendations.

I have a two week holiday break between the Masters Summit for Qlik in Prague 3 April and Qonnections 23 April.

My wife Linda favors warm so we are heading south.

Through my experience with this site and the greater Qlik Community,  I’ve been  blessed to travel and make  friends all over the world.  So now I’m reaching out to that larger community with a question that has nothing to do to with Qlik or BI.

Should we spend two weeks in Southern Spain or one week in Spain and another in Morocco?

I’m expecting to hear from my Portuguese, Greek and other friends as well 😉

Where would you go with those two weeks in April?




QViewer Acquisition

I’m pleased to announce that I’ve acquired the excellent QViewer tool from Dmitry Gudkov effective January 1.  I’ll be marketing, developing and supporting QViewer going forward.

QViewer has a stellar reputation as a must have tool for Qlik Developers.  I’m pleased to be taking over such a fine product.

This acquisition is one step in my plan to focus more on software development during 2018.  Stay tuned for other announcements during the year.

Existing licensed QViewer customers should email future support requests to

Happy New Year!



Is Data Beautiful? The Art of Adrien Segel

This past spring I enjoyed a glorious week of whitewater kayaking with Noah Weinstein at the incredible Otterbar Lodge on Northern California’s Salmon river.

Noah runs the Artists In Residence program at Autodesk’s Pier 9 Workshop in San Francisco.  Autodesk is a long time big QlikView customer and the Pier 9 Workshop is a working lab that demonstrates and tests practical applications of Autodesk products.

During downtime at Otterbar Lodge, Noah introduced me to the work of sculptor Adrien Segel.  Adrien sources data sets of observations from the natural world and transforms those data into beautiful, fascinating and challenging sculptures.

Adrien’s “Wind at Ravenswood Slough” project visualizes wind speed and direction over a 48 hour period at a single location. The Y-axis (vertical) represents time, the X-axis (length of the bars) represent speed — and here’s the advantage of a physical 3-D rendition — the Z-axis indicates wind direction.

Mount wind-at-ravenswood-pic1the finished sculpture  at the site where the data was collected and you have a deep understanding and delightfully personal relationship with data.  Brilliant!





Check out some of Adrien’s other projects like the  Snow Water Equivalent Cabinet  I found this dataset personally  interesting because of my love of rivers and river seasons.  Adrien takes a direct approach in mapping the data and the  result is a functional, fascinating  and intimate piece of furniture.

Can data be beautiful?  I think so.







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.