To follow up on my cardinality post, a very useful function is AutoNumber. AutoNumber will create an integer for each distinct value in your defined namespace, which is usually a field. The second parameter, allows you to define the namespace, which means you can use...
One of the key things to understand when trying to tune a Qlik app for performance is understanding the innerworkings. If you haven’t done so already, I very strongly suggest you read Henric’s blog Symbol Tables and Bit-Stuffed Pointers which goes into detail on how...
Most loops you will see are For loops. These are great if you can programmatically determine the number of loops you need to do. For example the number of rows of a table. However, what if you need to loop as long as it takes to finish? You don’t know how long it will...
We want to help hospitals and other healthcare providers plan and procure enough equipment to meet the huge demand for their services. The coronavirus pandemic is placing a tremendous strain on society and especially on healthcare providers. Hospitals are facing...
This is a post that might be common knowledge to you, but if not this can be a crucial addition to your workflow. ApplyMap is a function that is very similar to VLookup in Excel. Essentially you can utilize a mapping table that you can bulk find and replace, provide...
