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 clicked on the Dimension name, the relevant List box would pop out. This is not dissimilar to how the Filter pane works in Qlik Sense when there are several Dimensions added and not enough room to display values:
The Cookbook presented an alternate option whereby a Container is used to contain multiple List Boxes:
It worked quite well (in my humble opinion!)
Now, there is also a Container object in Qlik Sense, so we can achieve something similar. This is the load script from the Cookbook:
LOAD * INLINE [
Country, Product, SalesPerson, Category, Sales
USA, Widget, Joe, Widgets, 1234
USA, Woggle, Joe, Widgets, 1983
USA, Brogue, Jane, Footwear, 1175
USA, Clog, Jane, Footwear, 1376
UK, Widget, Tom, Widgets, 954
UK, Woggle, Tom, Widgets, 953
UK, Brogue, Tom, Footwear, 989
UK, Clog, Tom, Footwear, 875
Japan, Widget, Mike, Widgets, 1265
Japan, Woggle, Mike, Widgets, 1345
Japan, Brogue, Jane, Footwear, 1425
Japan, Clog, Jane, Footwear, 1324
As well as holding a Master's Degree in Data Analytics, Stephen Redmond is a practicing Data Professional of over 20 years experience. He is author of Mastering QlikView, QlikView for Developer's Cookbook and QlikView Server and Publisher.