QlikView Generating Year over Year Targets

From time to time you have to create budget figures upon a percentage change compared to the last year. This can be a little bit difficult, depending on the complexity of the KPI. The following example is build upon a pre-cleaned datamart and shows how you create the monthly figures for you budget.

As […]

Read More →
QlikView Script Sub for Dataloading

Sorry, typo in the path variable, now fixed! Enjoy the script!

Read More →
QlikView Generate Dynamic Variables

Sometimes it could be very usefull to generate variable dynamicaly, in QlikView you can do this easily with a trick inside the load statement of you application! Here is a short example (will give you some examples for a smart usage later):

Read More →
QlikView BestPractice – Keep your solution simple!

Introduction I develop QlikView solutions now since more than 4 years and I write software since more than 15 years 😉 damn I’m getting old… So as I started to work with QlikView I was more than fascinated by the “easyness” of getting results shown. But als live seems to be simple, the real world […]

Read More →
Geolocating with QlikView and Yahoo Placefinder REST API

Why? Everyone who analysis company or private data has a regional aspect. Knowing your customer although means to know where he is located. As I found a lot of interesting HowTo’s on the internet, but sadly none that really fits my needs… I decided to write a complete HowTo for QlikView and Yahoo’s Placefinder API. […]

Read More →