Qlikview Lookup Function

This post demonstrates the use of the Qlikview Lookup Function.  For my use case, I am connecting to SQL Server Express 2014, using the AdventureWorks2012 database.  I connect and pull in the “all_objects” system table, then build a second table using the LOAD Resident technique. Qlikview Version:  Personal Edition 12.0.20100.0 SR2 64-bit Edition (x64) OS:  Windows … Read more

SQL NULL

When working with tables in SQL, you will sometimes encounter field values that are empty or missing, which is referred to as NULL.  This occurs during the creation of a record in a given table, when the field is not required to have a value.  This differs from zero values or spaces, and cannot be … Read more

SQL CHOOSE Logical Function

The SQL CHOOSE Logical Function returns the item at the specified index from a list of values in SQL Server.  I’ve used it sporadically, but it equates to a work around for the CASE statement, making the query a bit more readable in some instances.  Let’s get to a couple examples. SQL CHOOSE Logical Function … Read more