There are many functions and techniques within Qlik Sense that one might forget to recall when a challenge is presented. These functions can always use practical examples of implementation and use case scenarios. Let’s look at the FROM_FIELD function in Qlik Sense. Load * FROM_FIELD Load * FROM_FIELD is a useful script function in Qlik Sense that allows you to parse the contents of a single column into many columns or rows. Here are some practical examples: Address: Client Addresses are captured within a single column on the source system. Financial: Chart of Accounts – Allows the jagged hier ..read more

There are benefits to publishing and distributing your NPrinting reports to the Qlik Sense Hub. You can access Qlik Sense apps and Qlik NPrinting reports in the same place and users will only have to log in to one central platform. In this post, we will show you how to: Set the Qlik Sense Hub as a Destination Publish and distribute Qlik NPrinting reports to the Qlik Sense Hub. Requirements: Qlik NPrinting version 17.1 or later Qlik Sense 3.0.1 or later It is also important to note that you can only distribute Qlik NPrinting reports to Windows domain users you have configured in both Qlik N ..read more

In this post, we’ll review two elusive methods within Qlik by which key business questions can be addressed: Qlik Set Analysis and Qlik Set Operations. A common business objective is to expand product sales or determine strategic effectiveness.  These problems generally take a form like one of the following questions and are asked with an eye toward historic performance. Which of my current customers purchased my product? Which of my current clients are benefitting from my programs? Qlik provides an array of tools to aid in the answers to these questions.  We will use Qlik Set Anal ..read more

If you want Qlik Sense objects in your reports, you must connect your Qlik NPrinting to a Qlik Sense app. In this post, we show you how to do just that. Requirements: Qlik Sense 2.3 or later Qlik NPrinting 17.2.1 or later It’s also important to note that the Qlik NPrinting Engine service account must be a Windows domain user. This user must also be given RootAdmin authorization in the Qlik Sense QMC. Without this you will not be able to connect successfully. Unsupported Qlik Sense Objects We do not recommend creating connections to Qlik Sense apps that use: Always one selected value for fie ..read more

Recently I have inherited an asp.net core application, which is also my first time working with the framework. Working with the application initializing controllers felt very repetitive since all controllers used a few common services like loggers. ASP.NET core makes service access easy with dependency injection, but it’s challenging to stay true to the DRY principle when every controller is initialized with the same few services.  In the code above, a few of the services being injected are also being used in other controllers. So, it becomes very repetitive to have to initialize all con ..read more

Adding calculations to your Planning Analytics model, like a YTD measure, provides users with the values they need without having to export data and do the math themselves. Determining what calculations will be most useful in your model is best decided after receiving feedback from users. Why? Because conversations about what data they’re extracting and manipulating themselves leads to a more comprehensive model. Calculating measures in the format your users need will save them time in having to add values up themselves, and inevitably making a mistake every now and again. A YTD measure is an ..read more

Qlik Sense offers a self-service business intelligence environment for business users to explore data and generate insights. Further, users can create their own dashboards or reports, all without having to rely on IT, data scientists, or analysts. Self-service BI gives all employees access to insights that will help them make better decisions, regardless of analytics skills. The premise of self-service also means that Qlik Sense users can create sheets within an application that often will need to be merged into the original base application. A possible scenario of this is Sales Rep A, a profe ..read more

There may be instances where you’d like to calculate the cumulative sum in a chart in Qlik Sense. For example, you may want to look at sales values cumulatively summed in a bar chart for selected invoice months. On the other hand, maybe you want to accumulate subscription dollars over time to see how individual companies are growing within your ecosystem. Cumulative sums or accumulation is possible in Qlik Sense; however, it may be challenging for the novice user to write the expressions to accomplish this. Formerly, in QlikView, you could select the ‘Full accumulation’ setting on the Expressi ..read more

John Daniel Associates has been delivering Business Intelligence (BI) solutions to our clients for 25 years! Yes, we are celebrating 25 years of helping people within companies looking for better, faster, easier ways to look at the intelligence gained from their data to help improve their business. So many things have changed over the years, and yet so many others stayed the same. In this post, we share the story of John Daniel Associates. It all began in 1996… What was going on in the world in 1996? Pokemon was introduced to the world In January 1996, there were 100,000 websites (6 bill ..read more

While Qlik offers abundant system-wide logging, application specific logging remains somewhat inaccessible. Moreover, it is difficult to configure and requires parsing to obtain what is required. In this article, we’ll construct a custom function that leverages existing Qlik Script logging. This will make message customization and retrieval simple, effective, and reusable. Table of contents Logging is critical to application development Leveraging Qlik script logs Qlik log files 1: Adding Log Messages via Trace 2: Leverage dynamic variables to specify custom message 3: Reuse Code with SubRout ..read more