Qlikview Inner Keep

This post demonstrates the use of the Qlikview Inner Keep Load Script prefix. For my use case, I am loading an Inline table with sample transaction data, then using the Inner Keep prefix in a separate code block, which references the resident table.  The result will filter down or reduce the initial table content, to … Read more

Qlikview Subfield Function

This post demonstrates the use of the Qlikview Subfield Function.  For my use case, I am loading an Inline table with sample column data, then creating a second table with sample Qlikview Subfield Function use cases, using the LOAD Resident technique. Qlikview Version:  Personal Edition 12.0.20100.0 SR2 64-bit Edition (x64) OS:  Windows 10 From Qlik Help: … Read more

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