It has been a blast! Back in 2013, Qlik launched something called The Qlik Luminary Program with 10 "Charter" members drawn from some of their larger customers. At the time, to be honest, I didn't really pay a lot of attention to it. I didn't know any of the charter members, and I didn't really know what the program was for, or even how to get involved with it. I was also pretty busy with other stuff! As well as spending my days pretty much working all the time with QlikView, and leading a team of QlikView developers, I had just published the QlikView for Developers Cookbook that June and was ..read more

It has been 7 years since the QlikView for Developer's Cookbook was published!  The book, which was very much targeted at QlikView developers, is still available. Just for fun, I thought that it might be interesting to write a series of posts looking back at some of those recipes and seeing how they could be recreated in Qlik Sense Business. In this post, I'll look at the recipe on Using containers as an alternative to multiboxes. For those who are unfamiliar with the QlikView Multibox, it was a way for us to add multiple filters into a relatively small area: When a user click ..read more

It has been 7 years since the QlikView for Developer's Cookbook was published!  The book, which was very much targeted at QlikView developers, is still available. Just for fun, I thought that it might be interesting to write a series of posts looking back at some of those recipes and seeing how they could be recreated in Qlik Sense Business. In this post, I'll look at the recipe on Section Access Gotchas. In Qlik, Section Access is the area of script where we connect users to the data to allow row-level security. It is very powerful and relatively easy to implement for many typi ..read more

It has been 7 years since the QlikView for Developer's Cookbook was published!  The book, which was very much targeted at QlikView developers, is still available. Just for fun, I thought that it might be interesting to write a series of posts looking back at some of those recipes and seeing how they could be recreated in Qlik Sense Business. In this post, I'll look at the recipe on Blocking user access to a field using OMIT. Picking this one was spurred by a message last week from a good friend who reminded me of a blog post that I wrote on the topic back in 2011! Privacy of fie ..read more

It has been 7 years since the QlikView for Developer's Cookbook was published!  The book, which was very much targeted at QlikView developers, is still available. Just for fun, I thought that it might be interesting to write a series of posts looking back at some of those recipes and seeing how they could be recreated in Qlik Sense Business. In this post, I'll look at the recipe on Consolidating a date-time value into quarter hourly segments. The premise behind this recipe is one that is relatively straightforward, we would like to round down Time Stamp data to a less unique val ..read more

It has been 7 years since the QlikView for Developer's Cookbook was published!  The book, which was very much targeted at QlikView developers, is still available. Just for fun, I thought that it might be interesting to write a series of posts looking back at some of those recipes and seeing how they could be recreated in Qlik Sense Business. In this post, I'll look at the recipe on Creating a dynamic part-to-whole pie chart. Now, I know that pie charts are not everyone's first choice, but for part-to-whole comparisons they work just as well, if not better, than other alternative ..read more

It has been 7 years since the QlikView for Developer's Cookbook was published!  The book, which was very much targeted at QlikView developers, is still available. Just for fun, I thought that it might be interesting to write a series of posts looking back at some of those recipes and seeing how they could be recreated in Qlik Sense Business. In this post, I'll look at the recipe on using TOTAL to calculate the percentage of total and subtotal. I like this recipe because it really helps to understand the power of the TOTAL function, which has been a core part of Qlik for a long t ..read more

It has been 7 years since the QlikView for Developer's Cookbook was published!  The book, which was very much targeted at QlikView developers, is still available. Just for fun, I thought that it might be interesting to write a series of posts looking back at some of those recipes and seeing how they could be recreated in Qlik Sense Business. In this post, I'll look at the recipe on Replacing the legend in a line chart with labels on each line. The idea here is that the legend on a chart can be somewhat removed from the data and not always easy to match the colours to the lines ..read more

Episode 14 of the Qlik Virtual Meetup Scotland (QVMS) had some very interesting speakers. Old friend and fellow Luminary, Barry Harmsen, from Bitmetric, was talking about his sensetheme.com site, so I thought that I might delve a little into the idea of themes and explain why I think it might be a good idea for you to explore them. For some historical context, the idea of Themes is not new to Qlik. Anyone who has used QlikView will know to what level of detail you can specify colours, various fonts, borders, shadows, etc. on various objects and then use the Theme Maker function to export those ..read more

A ..read more