Monthly Archives: April 2013

Win a free copy of QlikView 11 for Developers at #Qonnections

QlikView 11 for DevelopersFrom April 7 – 10 it’s once again time for QlikTech’s yearly partner conference: Qonnections.  Should you be fortunate enough to find yourself in the beautiful Bahama’s, we’ll sweeten the deal even more with a chance for you to win 1 of the 10 free copies of the book QlikView 11 for Developers that Mike and I will be giving away.

What’s the catch?

All we want from you is a Tweet. Be creative, tell us why you should get a free copy and don’t forget to include the hash tag #Qonnections and a link to the book’s page http://bit.ly/QV11Dev. On Monday 8th and Tuesday 9th of April, we will pick 5 winners and will announce them on this page.
Tweet to win!

Important: You have to be able to pick up your book (or have someone pick it up for you) at the conference on either Monday, Tuesday or Wednesday.

Of course, should you be interested in a meet-up with one or both of us, feel free to ping us via Twitter: @garciammiguel or @meneerharmsen.

But I’m not in the Bahama’s!

No worries, we’ve thought of you as well! Our publisher has graciously agreed to provide a promo code that will give you 20% off the price of the book:

vq2peb

You can use this code at the Packt website until May 5th 2013.

WHEN and UNLESS

Mr. ComplainypantsNo, this post isn’t about that negative co-worker or friend who’s always second-guessing your ideas and solutions, it’s about two QlikView script statements that I believe deserve a little more attention: WHEN and UNLESS. (Inspired by Steve Dark’s post on Hidden QlikView Features)

Both statements can be used as an easier, shorter version of the IF-THEN-END IF statement. For example, to set the default value for a variable, but only if it hasn’t been set already:

WHEN ‘$(Variable)’ = ” SET Variable = ‘Value’;

Or, another example, when you’re in a loop and want to add a separator to a concatenated value, unless it’s the last iteration of the loop:

UNLESS $(i) = $(ForMax) LET Variable = ‘$(Variable);’;

One thing you’ll immediately notice when you use these statements is that QlikView syntax highlighting doesn’t seem to recognize them. Don’t worry though, as the attached example application demonstrates, they do really work.

Download the example application