This post is getting into the systems management side in that it puts forward a naming convention for tasks in the Qlik Sense Management Console (QMC).

Where task management becomes more complex is if there are a lot of reload tasks or relationships between tasks such as dependant task triggers.

Sometimes it makes more sense to use a QVD to load your data from than the source. This might be for testing, performance or development reasons or maybe just because the day ends with a ‘y’.

This script is an example of how to loop through all of the tables in a data model and create a series of QVDs. There is an optional variable (vDebug) you can use to trigger whether this works.

The script should be placed after all the other processing eg on the last Tab or Section.

Data comes in all shapes and sizes and sometimes, the users of the data want to see this as a series of metrics eg as key performance indicators. As always, there are not of ways of handling this and for a quick way in Qlik Sense you can use some generic logic to build a KPI data set that you can keep expanding.

This post demonstrates how relatively simple it is to enhance the capabilities of TM1 with AI infused natural language query (NLQ) to assist with interpreting your data using Python with TM1.

Examples like this using NLQ support a broader (non technical) user base and help to transform the activity focus from lower value information collation to higher value data analysis.

This example demonstrates one (of many) methods for using an opening balance rule to roll forward balances between financial years using some of the calendar capabilities detailed in previous posts.

Have you ever forgotten to roll over your date related subsets or would you like them to automatically roll with the punches dates?

In yet another date related post, this time the focus is on creating dynamic subsets for a year and month dimension by leveraging the calendar cube from a previous post.

Extending from the last post on incrementing dates in Planning Analytics (TM1), this post looks at how to build a simple Master Calendar cube that can be leveraged in rules and TurboIntegrator (TI) processes.

These examples demonstrate how, in TurboIntegrator and rules notation, dates can be incremented by years, months or days.

One of the neat features in Power BI is the ability for a user to create a calculation at any of the modelling tiers. This example is aimed at the end user who wants to add a dynamic calculation, in this case to calculate an average sale price using a combination of Amount and Quantity.