Please contact us for more information about how we can help with Data Warehouse Design/Development, Business Intelligence and Analytics related services: 614-505-0770 or email us at sales@resultdata.com. About the Webinar: A one-hour Webinar that was presented on April 25th, 2017 about the challenges and options associated with implementing a unified data analytics and reporting platform. This […]
Qlik Custom Calendars (for Qlik Sense & QlikView)
Qlik Sense and QlikView both handle dates via list boxes (or Filter Panes in Sense). The conventional approach to providing users with date selectors is to create a master calendar and create list boxes in the application to select things such as “Year”, “Month” and “Quarter”. This works well enough, and it addresses issues with missing dates […]
Qlikview – Inputbox as a filter
Recently, I was working with a client who wanted to make it easier for end users to be able to do complex associative searches in a list box. A few examples of how associative searches can be used in order of increasing complexity: 1) Search for all Suppliers whose name starts with the letter S […]
Qlikview Sorting by Multiple Expressions
I was recently working with a client who needed to use a list-box rather than a straight table to show a list of values and some measures. The reason for the list-box was that, unlike a chart, when the user makes selections, we can set it up so that all values continue to be shown […]
Key Concepts of Qlik Sense – Part I (The Hub)
Qlik Sense is a web-based application with different areas to work in. You chose which area to view depending on what you would like to see in the application. There are areas to see the data model, work with storytelling, or exploring data. On startup, Qlik Sense will open up the hub in your default […]
Benchmarking QlikView Load Script Strategies
I recently worked on a project that involved improving the performance of a user developed QlikView document load script. The problem I was told was that the reload took approximately 12 hours to complete. The request that I received was to examine the document and improve the data model and load strategy. One issue that […]
Qlik Sense Load Order Sorting
QlikView Developers have long used load order sorting to provide a custom or business rule driven sort order. Load Order sorting provides a simple way to sort values in an expected order without resorting to a numeric prefix, hidden sort fields or other techniques. Some common examples of lists commonly sorted in non-standard orders are […]
Qlikview SQL Timer – see how long each query takes
About a year ago I was working with a client to clean up a series of Qlikview load scrips that had grown to be quite lengthy over time. Each of the scripts consisted of several SQL queries. As part of the process to investigate the queries, I was asked if there was a way for […]
Qlikview Developer Macros
When I am designing a Qlikview application, I often create a sheet that is essentially a draft area. It’s a place where I can drop text boxes, list boxes, and all manner of items that have nothing to do with the actual dashboard. This sheet is just for me to run tests and validations; I […]
How to add diff icons to gutter in sublime text 3
I’m adding this blog post more or less for future reference. I often find myself putting together new virtual work environments or working on client systems. In these cases, I need to set up Sublime to work the way I like it. One of the things I like the most, is the ability to see […]