Qlikview

Qlikview Remove Unwanted Characters with PurgeChar Function

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

0 comments

Qlikview Set Analysis – Periods

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

0 comments

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

0 comments

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

0 comments

Qlikview Quick Tip – Exit Script

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

0 comments

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

0 comments

Qlikview Visual Cues – Highlight Maximum and Minimum Aggregate Values

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

0 comments

Qlikview Set Analysis – Define Specific Value Against Current Selection

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

0 comments

Qlikview Sort Table Box with Button

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

0 comments

Qlikview Max Number Straight Table Chart

The following post demonstrates how to define a fixed number of rows to display in a Straight Table Chart.  The “Max Number” property in the Presentation tab of the Straight Table Chart properties windows can be used to accomplish this task.  This comes in handy when you are looking for a simple way to display … Read more

0 comments

Qlikview Display Table Counts Before and After Reload

About a week ago, I was working on changes for a Qlikview application when the user asked me how the record counts for a given table changed, following the most recent refresh.  This got me thinking about ways I could display the changes, which led me to creating this post.  The following details a simple … Read more

0 comments

Qlikview Dropdown Select Column in Table Box

Sometimes in Qlikview application design, I find there are too many List Boxes cluttering up a given page.  There are many different techniques to reduce the number of List Boxes being displayed, and this post demonstrates one of these techniques.  This particular example involves setting up a Qlikview Dropdown Select Column in a Table Box … Read more

0 comments

Qlikview Export to Excel Tabs with Formatting

Qlikview Export to Excel Tabs with Formatting – Exporting content to separate Excel tabs based on selected field, with additional formatting in Excel once the data is exported The following post is the third in a series covering the Qlikview Export to Excel (tables, charts, listboxes, etc.) process. You can view part one here:  You can view part two here:  In … Read more

1 comment

Qlikview Button Run Macro

This post demonstrates how to use the Qlikview Button object to run a VBScript Macro.  In some instances, you would like to setup buttons within your Qlikview application, allowing users to initiate actions to interact with the app.  Qlikview Button objects provide a robust set of actions you can setup to accomplish various tasks.  The focus of … Read more

0 comments

Qlikview List Box Show Frequency

This post demonstrates how to use the Qlikview List Box Show Frequency property setting.  The Show Frequency property setting allows you to display the frequency that a List Box value appears in a specific field.  This is very useful setting that provides a lot of information to the user, without having to create a chart to display … Read more

0 comments

Qlikview Binary Load

This post demonstrates how to load data from another QVW file, referred to as Qlikview Binary Load. From Qlikview Help:  The binary statement is used for loading the data from another QlikView document, including section access data. It does not load the layout information or variables.  Only one binary statement is allowed in the script … Read more

0 comments

Qlikview List Box – Display only Active Values

This post demonstrates how to configure a Qlikview List Box to display only active values.  This comes in handy when you are trying to limit the contents of a List Box object, only to values that are possible to select, based on selections in other List Boxes.  I use this technique to display active “possible” … Read more

0 comments

Qlikview FirstSortedValue

In the following post I will demonstrate how to use the Qlikview FirstSortedValue chart function.  This is a useful tool when trying to determine the min/max value for a specific field, based on a given dimension. From Qlikview Help:  FirstSortedValue() returns the value from the expression specified in value that corresponds to the result of … Read more

4 comments

Qlikview Macro Field Event Trigger

This post demonstrates how to dynamically display a specific object based on the value selected in a List Box, using a Macro and OnSelect Field Event Trigger.  I recently needed to figure out how to split a table into smaller views so a user could see the data in a more user-friendly display.  All the data … Read more

0 comments

Qlikview Macro Loop through Items in List Box

In Qlikview, there are cases where I need to cycle through a given List Box object, performing actions based on the selected value.  I’ve used this technique to run reports, export data and visually walk an audience through changes in a chart based on the selected item.  In the following post, I will provide a … Read more

0 comments

Qlikview Import Microsoft Excel Data

In most jobs, people work with Excel every day.  It’s no surprise that importing Excel data into Qlikview is frequently required, which generates a lot of questions for new Qlikview users.  I often get questions on this topic, so I figured it would be a good topic to cover. Setup Here are the steps to … Read more

0 comments

Qlikview Import Microsoft Access Data

I don’t use Microsoft Access all too often these days, but I recently received a request to import data from a MS Access database into Qlikview.  I didn’t think much of the request until I started to work on the Load Script.  It took me a while to figure it out!  So I thought I would … Read more

0 comments

Qlikview Export to Excel Part 2

Qlikview Export to Excel Part 2 – Choosing Object to Export and Having User Determine Location/Name of File The following post is the second in a series covering Qlikview and exporting objects (tables, charts, listboxes, etc.) to Microsoft Excel.  In the first post, I covered a very simple macro to export a specific Table Box to a specific location.  You … Read more

4 comments

Qlikview Match

This post demonstrates the Qlikview Match Function, which is Qlik’s equivalent to the IN operator in TSQL. Just the other day I was working with a large dataset and decided to filter down the data in the Qlikview Load Script.  I was working with a Zip Code table, linking it out to a larger dataset with geographic … Read more

0 comments

Qlikview Export to Excel Part 1

Qlikview Export to Excel Part 1 – Simple Qlikview Export to Excel using VBScript Macro This is the first of a series of posts covering Qlikview and exporting objects (tables, charts, listboxes, etc.) to Microsoft Excel.  This topic is covered extensively on the web, but I wanted to break it down into steps, starting with the most … Read more

9 comments

Qlikview Format Multiple List Boxes

No matter what type of Qlikview application I work on, List Boxes are always prevalent.  In some cases, there are dozens of List Boxes on a single sheet. It didn’t take long to realize Qlikview does not allow you to format multiple list boxes at once, for many property settings such as “Show Frequency” or setting up … Read more

0 comments

Qlikview Capture ListBox Selections

I am working on a Qlikview application to analyze fantasy football statistics.  A common practice is comparing player stats, trying to determine which player to draft, start or pickup on your roster.  In many cases, I select multiple players from a ListBox and display them in various charts, in order to compare their statistics over … Read more

0 comments

Qlikview Dimension Background Color

During the NFL football season, I use Qlikview to breakdown fantasy football statistics, helping me make lineup decisions and player transactions.  I know, another fantasy football geek.  However, using the football stats in Qlikview has forced me to learn new tricks and techniques that I often apply to my professional work. Back to the example.  … Read more

0 comments

Qlikview Open URL

I was recently asked if Qlikview could open up a Web Page URL.  It seemed simple enough, add a link to a text box and move on.  However, the next question was how can you specify which page to open.  In other words, give the user options on selecting different Web Page URLs.  This prompted a little … Read more

0 comments

Qlikview Dimension Limit Based on Variable

In Qlikview charts (except Gauge charts and Pivot tables), you can use the Dimension Limits tab to control the number of dimension values you can see in a given chart. In this post, I will demonstrate how setup a Qlikview Dimension Limit based on variable.  The variable value is setup by an InputBox drop-down, then used … Read more

0 comments

Qlikview Mini Chart

I have been working with fantasy football data for a while now, so it is fun to come up with new ways to display the data.  At the same time, it has been a great way to learn about the various features and objects available in Qlikview.  In this example, I am going to show … Read more

0 comments

Qlikview RangeSum

From Qlikview Help:  Returns the sum of a range of 1 to N arguments. As opposed to the + operator, rangesum will treat all non-numeric values as 0. Here are a few examples of how to use the Qlikview RangeSum function Example 1 – Let’s say you simply want to display the sum of several … Read more

0 comments

Qlikview Macro to Capture Table Box Fields

Recently, I was building a Qlikview application and wanted to make the first row of a table box stand out to the user.  I felt the user needed to have an easy way of seeing the content of the first row, so they wouldn’t glance over it due to the abundance of objects on the page. Therefore, I decided to … Read more

2 comments

Qlikview Copy Chart Expression

When I first began using Qlikview, I unknowingly fell victim to a frustrating scenario.  While creating charts, I often needed to write out multiple expressions.  In many cases, the expressions were very similar in structure, with just a couple minor differences. I then stumbled upon the fact that you can actually copy an expression and … Read more

2 comments

Qlikview – Include Chart Caption in Copy Image

Not long ago, I got a request to email the contents of a chart for inclusion in a management report.  Seemed simple enough, I would simply right-click on the chart, copy the chart to an image on my clipboard, then send the image off to the analyst.  This is when I realized the default settings … Read more

0 comments

Qlikview Drill-down Dimension Group

By definition in Qlikview Help:  When several fields form a natural hierarchy, it makes sense to create a Drill-down group. When a Drill-down group is used as a dimension in a chart, the chart will use the first Fields in the group’s list of fields that has more than one possible value. If selections are made that … Read more

0 comments

Qlikview Cyclic Dimension Group

By definition in Qlikview Help:  Sometimes you may find it useful to group fields which do not form a natural hierarchy, enabling the user to make quick changes to the data to be displayed in the chart or list box. You can group any fields together in a cyclic group. By using a cyclic dimension group … Read more

0 comments

Qlikview IntervalMatch

By definition in Qlikview Help:  The Qlikview IntervalMatch prefix is used to create a table matching discrete numeric values to one or more numeric intervals. It must be placed before a Load or Select (SQL)statement that loads the intervals. The field containing the discrete data points must already have been loaded into QlikView before the … Read more

2 comments

Qlikview Export Chart to QVD

A QVD (QlikView Data) file is a file containing a table of data exported from QlikView.  These data files maintain the compressed/optimized traits of QVW files, prove to be efficient, and can be reloaded 10-100 faster than normal data sources. Recently, I was building an expression heavy straight table chart.  Unfortunately, a user was unable to filter the content because most … Read more

5 comments

Qlikview List Box

Once you have created your Qlikview application and loaded the data, the first task you will often perform is adding List Box objects to your sheet.  This is a very simple task: Right-click on your mouse, then select Add Object-List Box:     Or, right-click on your mouse, then choose Select Fields     You … Read more

0 comments

Qlikview Automatic Refresh

In the steps below, I will describe how to setup an automatic refresh of one single QVW file.  Any time I use this functionality, I keep it simple and refresh one single file per scheduled task.  I’ve seen more elaborate solutions over the years, but I like to keep things simple and avoid potentially complex … Read more

1 comment

Qlikview Custom Sort Order

In the following post, I describe how to setup a Qlikview Custom Sort Order, which allows you to control the way a field is sorted and displayed.  Whether it be in a list box, chart or visual, as a designer you want to make sure the data is presented exactly the way it is intended.  You would think that something as basic as … Read more

0 comments

Qlikview Bundle Load

The Qlikview Bundle Load allows you to associate an image or sound with an actual field selection.  As I mentioned above, this can be useful for aesthetics, adding a nice visual touch when a user selects a field value filter from a list box.  In the example I’m going to show you below, I will demonstrate … Read more

0 comments

Qlikview Trellis Chart

If you search Google for the definition of a Trellis Chart, it is defined as the layout of smaller charts in a grid with consistent format. The Qlikview Trellis Chart option does not work for pivot or straight table charts. Also, you must define two dimensions. The first dimension is the basis for the “grid” if … Read more

1 comment

Qlikview Select in Field

Recently, a Qlikview user asked me if there was an easier way to filter on a numeric field.  This seemingly simple task can be tricky, especially when there are many unique values, as there often is in a numeric field.  This has come up several times in the past, so it seemed to be a nice topic to post.  The action “Select … Read more

3 comments