qlik

LET’s Just Use One

There is a lot material on the community on explaining the difference between the functions SET and LET. The gist of it is: SET stores the variable with the expression string and LET will evaluate the...

Custom Property Security Rule Governance

Here is how you can utilize Qlik Sense’s custom properties to govern access to data connections, streams, extensions, and/or content libraries at a group level. First create a custom property: N...

Data Model To QVD

This script is used to export a data model to QVDs. This has been especially common since Binary Load, while available, is not supported in Qlik Sense. So for any multi-tiered app design I will have t...

Queuing

What is a queue? In programming terms it is very similar to every day life terms. When you stand in line waiting to order a coffee at the cafe, you are standing in a queue. It’s a systematic way...

Group By ApplyMap

Description This test is to determine whether or not you can do an aggregation/group by on a field using an ApplyMap in a single step. I.e. Not a second load. Result You can Raw: Load * Inline [ field...

Qlik Variable Scope

Purpose This document is used to track the limits of Qlik’s variable scope within the script as well as changes made on the front end. Tests Subroutines Observations: Variables created before a ...

QIB Install Notes

Purpose The purpose of this documentation is supposed to be supplemental to the documentation provided by Qlik. Their documentation is good aside for two particular components: Certificates Troublesho...

QABDI Install Notes

Description This document is meant to cover some of the configuration of the Qlik Associative Big Data Index (QABDI)  install. This is not meant to replace the installation document provided, this is...

Qlik Evaluation Plan

When building dashboards it is important to understand the order of operations when an expression gets executed. This will help you performance tune and help you identify which options are possible, v...