Qlikview | SQL Server | Power BI | Excel
Sometimes when building expressions in Qlikview, you need to setup a formula to read all possible records, regardless of the current selection(s) made. This is where Qlikview Set Analysis comes into play! There is a simple set identifier {1} you can insert into your expression that will do the trick. This post demonstrates a simple … Read more
This post will show a simple example of how to remove a specified character from a string coming in through the Load Script. The Qlikview PurgeChar function is a simple solution for this problem, and can easily be added to a chart or load script. From Qlikview Help PurgeChar() returns a string consisting of … Read more
Qlikview Set Analysis is a powerful tool allowing you to define a specific set or group of values that is different from the current selection specified by a user. This is a fantastic way to make comparisons in your dataset, as well as highlight specific values against the entire population. A set expression must be … Read more
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
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
I’ve been working with Qlikview for quite some time. Last week, a co-worker mentioned a quick tip regarding the Exit Script command. Over the years, I haven’t encountered the need for this frequently, but when I am building a LOAD SCRIPT spanning multiple tabs, and need to do incremental testing and development, the following tip … Read more
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
The following post will demonstrate how to use Qlikview Visual Cues in a Straight Table chart, to highlight the maximum and minimum values for each expression over a given dimension. In this example, I will setup the chart to calculate Average Point totals per year, for two teams. I use Set Analysis to isolate each … Read more
Qlikview Set Analysis is a powerful tool allowing you to define a specific set or group of values that is different from the current selection specified by a user. This is a fantastic way to make comparisons in your dataset, as well as highlight specific values against the entire population. A set expression must be … Read more
Recently, a user inquired about adding a button above a specific column so they could sort the column of the Table Box. I instructed the user to double click the column header and the table would sort accordingly. However, the user did not want to lose full visual of the column label, and there was … Read more