Happy New Year everyone and as storms smash against my window and clouds just can’t seem to stop dumping water on my head I start thinking of travel and holidays (picture below shows how stormy it really is close to where I live).
I live on the South Coast of England and I am lucky enough to be able to make frequent visits to Brittany in France with my wife. When we first started visiting our French was very basic. Whenever we wanted to order a meal we had to point at pictures and hope it was what we thought it was! This was ok to start with, the pictures made our life easier when ordering a meal, but what if we wanted to find out more? Then it became clear that a nice picture had its limitations. So we went to lessons and learnt how to communicate in French. It’s not easy to learn a new language, but it’s very satisfying. At last we can get behind the lovely picture of Croque Gagnet, and find out that it’s a toasted sandwich with Gouda Cheese and Andouille sausage!
So why the culinary tale of France? QlikView uses a scripting language to give access to some of the more powerful aspects in the platform. Some people feel that a scripting language is complicated and forms a barrier to the adoption of QlikView. “Au Contraire” I cry It is the power of the QlikView scripting language that leads us to more discoveries within our data. So let’s do some very simple scripting. I have a spreadsheet and it contains five pieces of information (fields), here is the script that QlikView uses to load that information.
(biff, embedded labels, table is Sheet1$);
So to translate, we are asking QlikView to find Customer, Zip, City, Address and Customer ID in the prescriber data spreadsheet. It’s just a matter of getting over that initial trepidation when learning something new.
I don’t expect everyone to be expert writers of QlikView script, the same as I am not an expert of the French language, in fact “je ne suis pas très bon”. So to get started on that journey here is how we help you out, we have free training and a free download of QlikView so what could be simpler! Start the New Year by learning a new language and explore the power behind the pictures.