Advanced QlikView 12 for Developers

It's not that uncommon for business users to require consolidated information from all sorts of different sources. In such a scenario, the developer commonly faces the challenge of adapting a user file (excel, csv, txt) that has either a non-standard structure or contains "dirty" data which needs to be removed, such as report headers or subtotal lines, and sometimes both. Let’s see how to address this issue! 

A more common example of a source table that is unfit for QlikView is the Crosstable. This video lets you understand why it's not suitable for a data model, and how can we transform it into a traditional table. 

This video will walk you through the usage of a hierarchy table, which is a common format to store information in a parent-child structure. The hierarchical nature of the table allows one value to be related to one or more values across the table, as a parent or as a child.

How can we store the attributes which are not necessarily shared across all objects contained in the table? Let’s answer this question with this video.

Simply put, variables in QlikView are used to store data, either static or dynamic, and they can contain text, numbers, or any other data type. They are stored as a separate entity and are given a name to be able to reference them from any object in the whole document. Let’s see how to use them!                         

How can we disregard chart dimensions and make the calculation over the entire record set as defined by the current selection state? Let’s get a solution to this problem.  

The Aggr function creates a virtual straight table, similar to the earlier one, so that we can further process the list of values that 

would appear in the expression column, without even creating the actual object. This video will show a practical implementation of this.

There are several conditional functions in QlikView that can be used in the frontend to give our charts a higher level of flexibility in terms of handling and presenting the data, both in expressions and dimensions. Let's go through some examples of these functions to enhance the analysis in our QlikView app.

Let’s introduce one of the most powerful tools you, as a developer, have at your disposal when creating QlikView documents.

Having the ability to perform period-over-period analysis is a basic requirement in any BI tool and is easily performed in QlikView with the aid of set expressions. However, needless to say, Set Analysis is also amazingly useful for the fulfillment of other special requirements. Let's combine the acquired knowledge and apply it to add Point In Time Reporting to our Airline Operations document. 

Let’s explore a feature available in QlikView since version 11 which makes it easy to create highly dynamic comparative scenarios that enables business discovery in an entirely new way.

This video will walk you through useful techniques for optimizing loads when processing data. Let’s go ahead and learn another useful way of reading source tables, but this time the "source" will be QlikView itself. There are different cases in which this approach will prove useful.

This video will show you, how you can implement a document segmentation scenario by aggregating the Flight Data table to create a second document intended for executive users, who only require summary data. 

Let’s get introduced to the Order By statement, which is added to a Load statement and is used to sort an input table based on certain fields.

On their own, the Order By statement and the Peek function are already powerful. Let’s combine both of these tools to enhance our input data. In this section, we will use both of these functions to add a new calculated field to our Employment table

A slow changing dimension is one whose values vary across undefined time periods, that is, it can have different meanings depending on the time period context. Let’s see how to deal with different scenarios related to this.

How can you transfer data from one database to another efficiently and avoid the unnecessary use of resources? This video will provide you with an answer to this!                         

Let’s see how to make sure that the user interface, which includes language, layout, and design, is as consistent as possible. A consistent user interface makes it predictable for the user, they will have a better understanding of how things work, and will feel more in control.

Besides properly styling your QlikView documents, how your document responds to user interaction is also critical to ensuring a pleasant user experience. Let’s see how to work on this!

When QlikView script is being executed, the results of the actions are written to the Script Execution Progress window. While this is a very useful feature to see what happened during reload, sometimes you do not want certain things to be visible to everyone. In fact, sometimes you do not even want all developers to have access to the entire script. This is where the hidden script comes into play.

Setting up user authorization under QlikView is generally referred to as section access, named after the statement that initiates the authorization section of the script. This video will show its implementation.                         

How can we associate additional fields with the security fields to reduce the set of data that individual users have access to? Let’s get an answer to this question!

User privileges can be set on two levels within QlikView, at the document level and at the level of individual sheets. This video will walk you through the essential steps to implement these two security levels.