Monthly Archives: November 2015

Join me in the Qlik Sense Cloud

Qlik Sense CloudWant to build a quick dashboard or analyze some data? Want to share your findings with others or publish charts on social media? Then the Qlik Sense Cloud might be of interest to you. This cloud version of Qlik Sense has been available since September 2014. While it is still in beta, features are steadily being added. Best of all, it is completely free!

You can upload up to 250MB of your own data, but can also get external data from the Qlik DataMarket (for example information on exchange rates, demographics, weather or businesses) to augment your internal data.

 

A use case

The missus and I are expecting a baby early next year. Picking a name, in my opinion, is no easy task. I don’t want my kid to have the same name as 5 other kids in his class, but also not a really obscure name (like “Bamboo”, “Patient”, “Berlusconi” or “Zorro”, names that were actually given to some unfortunate kids in the Netherlands in 2014). To make things a little easier, I downloaded a list of all the baby names that were given in the Netherlands in 2014, loaded it into a Sense Cloud App and shared it with my wife. Now we can easily filter names based on popularity, length, letters, etc. and see what we like. It’s nothing too fancy, but the fact that we can use it from a tablet or our phone without having to install anything makes it a lot more convenient and fun.

Want to try the Qlik Sense Cloud?

If you would like to give the Qlik Sense Cloud a try, then enter your email address in the form below. You will then automatically receive an invite for my shared space on the Qlik Cloud. This will give you access to any applications that I publish to the Qlik Cloud and will also give you the option to create your own applications. (email addresses are only used to send the invites and are not stored)

Up to 50% discount on “QlikView 11 for Developers” this November

QlikView 11 for DevelopersThe good folks over at Packt Publishing are having a special promotion on our book QlikView 11 for Developers until November 25th 2015. Now is an excellent time to get the book if you:

  • Do not yet own the book (but want to!), or
  • ‘Borrowed’ a copy from the Internet before and want to regain some good karma, or
  • Are delivering our QlikView classroom training and want to replenish your stock, or
  • Want to give a gift to that special QlikView Developer in your life, or
  • Own the original version before it gets replaced by QlikView 12 for Developers (that might take a while), or
  • Have an exceptionally wobbly table that requires fixing.

If any of the reasons above apply to you, or if you have another good reason (would love to hear them, please comment 😉 ), then feel free to use the following discount codes:

Discount code
Discount Book version
QLIKVIEW50 50% eBook – English version
QLIKVIEW20 20% print book – English version
QLIK50ESP 50% eBook – Spanish version
QLIK20ESP 20% print book – Spanish version

 

Remote include scripts

Got a bunch of scripts here for you, where do you want me to put them?One of the reasons why I like QlikView so much is that there are always new functions and applications to discover. Yesterday I was at a client who is a Qlik OEM partner. During lunch we discussed various uses of include scripts. The question came up if it was possible to remotely update include scripts. At the same time they didn’t want these external scripts to be viewable (they sell a solution based on QlikView, clients get the solution but the OEM owns the code). Of course, that makes things a little more complicated. The include script sits outside of QlikView in plain text, so anyone can read it. Besides that, updating an external script that sits on the client’s local server is also not a straightforward affair.

I started wondering if it might be possible to fetch an include script from a remote website. So I just tried it, and it works!* (in QlikView, Sense requires Legacy Mode to be enabled, I will let you decide if that is a good idea)

Try this one for example:

$(must_include=https://www.qlikfix.com/remote_include/?license=12345);

In my opinion, this opens up some interesting use cases:

read more »