Category Archives: General

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

Qlikview Cookbook Online

My “Qlikview Cookbook” is now available online at QlikviewCookbook.com 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 RobWunderlich.com 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!

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

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!
Share

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.

-Rob

Related posts on Alerts:
http://qlikviewnotes.blogspot.com/2010/09/monitoring-reload-schedule.html
http://qlikviewnotes.blogspot.com/2010/12/alert-questions-answers.html

Share

Welcome to the Qlikview Cookbook Online!

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 RobWunderlich.com over 20,000 times.

It’s time for a major update to the Cookbook. For the update I’ve created this website as an expanded delivery vehicle. In using a website, I hope to make it easier for you to discover relevant examples and make it easier for me to maintain.

I’m still open to creating single-file archives of most content — like the old Cookbook — if there is demand for it.

If you have any comments or feedback please use the Contact form.

-Rob Wunderlich

Share

Quick Tip for Exploring Your Data Model

I picked up a great tip from QlikCommunity to view field values in your data model:
http://community.qlikview.com/thread/89396

I refined it a bit and am finding it very useful.

1. Create a listbox for field “$Field”.
2. Create a Straight Table Chart with:
  a) Calculated Dimension:  =$(='[‘ & only([$Field]) & ‘]’)
  b) Expression:  =sum({1}1)

Select a $Field in the listbox and the field values and frequencies will appear in the chart. Very handy for exploring data values in your model.

-Rob

Share

Book Review: Qlikview for Developers Cookbook

I just finished the excellent book “Qlikview for Developers Cookbook” by Stephen Redmond, available from Packt Press. The book contains approximately 100 short “how to” examples of Qlikview visualizations, calculations and scripting.

(Note: This book is not related to my “Qlikview Cookbook” available at http://robwunderlich.com/downloads/. The books are similar in aim, but Stephen’s is a full print book with entirely new content.)

This is an excellent reference for many QV tasks and a good way to learn no matter your level. I picked up quite a few new tricks. The book organization is good, the examples clear and short. The “How it Works” explanations are gems. Stephen’s experience is broad and he freely shares his advanced knowledge.

I highly recommend this book for all QV developers. You’ll recover the purchase price with one tip!

The book is available in print and e-book. The print version is in black and white, and I found some of the figures hard to understand without color. The e-book uses color and is much easier to follow, so I recommend the e-book.  Interestingly, at this moment, you can get the print and e-book together for less than the cost of the e-book alone. Go figure!

Congratulations to Stephen for an important contribution to the growing library of QV Publications.

Share

Masters Summit Coming to Europe

I’m excited to announce that the Masters Summit for Qlikview will be coming to Europe in October 2013. Two dates and locations are announced:

  London, UK 9-11 October 
  Barcelona, Spain 14-16 October

Join us in either location for 3 days of hands on sessions where we will bring some of the leading QlikCommunity contributors to you live to discuss advanced techniques in building complex solutions with QlikView. The goal of this event is to take your QlikView skills to the next level and help you become a QlikView  master.

The inaugural Master Summit was held in Las Vegas, Nevada, in April 2013, with over 60 attendees from North America and beyond. Check the website for feedback from attendees at the Vegas Summit.

Program details and registration information can be found on the Summit Website. I hope to see you in Europe!

-Rob

Share