Emulating dynamic labels in Qlik Sense

Currently, in Qlik Sense data columns labels are just static strings that do not evaluate variables and macro expressions. For me, that is one of the most nagging limitations in Qlik Sense. I’ve made an extension named Dynamator, that adds such functionality to Qlik Sense (albeit with some serious limitations too). As usual, the extension itself and sample application that demonstrates its usage are available for download. The sample application is somewhat like application in old Emulating cyclic dimension group in Qlik Sense post. Read On →

Emulating document chaining in Qlik Sense

In QlikView document chaining is drilling down from one application to another automatically transferring selections. The current version of Qlik Sense (2.0.1 beta) does not support document chaining yet,but with some efforts, we can achieve a very close approximation of that functionality. To make a sample I’ve created a couple of applications with identical models (with load scripts copied from QlikView Script editor’s Test script). First application, AppChainingMain, would play the role of a master dashboard (nothing fancy, just one sheet with a Pie Chart and couple of list boxes to filter data) Second application, AppChainingDetail, is similarly basic in design and consist of one table with transactions details Our goal will be to add the drill-down feature from AppChainingMain into the AppChainingDetail with current selecitons transferred. Read On →

We are changing name

My company just changed the name from InQlik to InfoVizion. So I’m moving that blog to a new location at our domain. Old posts will be accessible on old location, but new materials will be posted only to new blog.

InfoVizion QVD Explorer

TL;DR: Check out our QvdExplorer - simple but powerful tool to explore data in your QVD files In that post I want to introduce simple tool that our team internally use quite some time. We use it to analyze data in intermediary and Ready-For-Mart QVD files in our projects. Basically QVD explorer consist of two parts: QlikView application template with dynamic data exploration functionality. Application provides dynamic selection of dimensions, measures, filters based on data loaded in concrete application. Read On →

Online tool to check syntax of QlikView expressions

TL;DR: Check our on-line parser for QlikView expressions Currently in spare time I’m trying to add command line syntax check tool for QlikView’s chart expressions to ours team tool-box. We already use internally similar command line parser for QlikView load scripts. It definitely should be improved in future but already now (integrated with Sublime Text as Build system for qvs script) it provide some help in developing process. It is developed in dart programming language with sources available at GitHub repository for all interested in that kind of stuff. Read On →

Sample of QlikView automation by external VBScript scripts

You can do all sorts of administrative tasks with QlikView applications through Automation API. Export charts to excel or csv files, export variables from application, set sheet level security parameters before deploying application or warm your application on server by automatically opening some sheets and selecting some most popular values in listboxes. In most cases I would code such a task not as a macro inside QlikView application but as an separate external VBSCript file. Read On →

Emulating cyclic dimension group in Qlik Sense

Current version of Qlik Sense Desktop do not support cyclic dimension groups (drilldown groups are supported). In this post I illustrate how to emulate this functionality. This method does not employ extensions objects and so on. Basically it uses additionally loaded field in island table and macro expansion in chart dimension. Sample applicaiton is available. Result looks like that: and like that (another dimension selected): That solution has some glitches in current version but I think it can be useful if you wish to reduce amount of almost identical sheets in your Qlik Sense application. Read On →

InfoVizion Expression Editor, part two

After writing previous post I have very interesting discussion with Jason Michaelides. Jason raised perfectly valid question about performance considerations of using = sign in variable definition. In my example I use it with dynamic labels and comments. Actually I never used sort of internalization similar to my sample and almost all labels and comments in our applications are pretty static. So after some thought and some unsuccessful attempts to make it work differently I gave up. Read On →

InfoVizion Expression Editor in QlikView Deployment Framework environment

We’ve switched to QlikView Deployment Framework recently so adjusting our current toolset to new environment was a great opportunity to rethink some approaches and implement some properties in alternative way. In this post I’d like to present some background design considerations and current state of one of these tools - Expression Editor. Expression Editor is a module in InfoVizion Tools - free open-source package for Sublime Text editor. Overview of Sublime Text itself you may find here Basically at the moment InfoVizion Tools consist of Language syntax plugin for qvs script files Integrated QVD metadata viewer Expression Editor Other parts of InfoVizion Tools may be subject of another post. Read On →

Dynamic number formatting in chart expressions. Pros and cons

First of all - a definition. QlikView charts properties dialog has a Number tab where we are setting formats for each expression manually. That I will name static number formatting in this post. Whole bunch of various controls together are helping user to set proper value to property Format Pattern. Importantly - Format Pattern can not be set by variable expression. So you can set Background Color or Text Format of chart expression by variable expression but not Format Pattern. Read On →