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 a “Top 10/20/25” list within a Straight Table Chart.  I will also show you how to link this display setting to a variable, where the user can determine how many rows to display using an Input Box object.

Setup – Qlikview Max Number Straight Table Chart

Let’s say you have the following chart:

Qlikview Max Number Straight Table Chart

This is a simple SUM of points per player over a given time period.  However, you’d like to restrict this to only display the “Top 10” players based on total points.

You could use dimension limits and customize the setting to display the Top N players within the cart.

Or, you can set the “Max Number” property in the Presentation tab of the Straight Table Chart property window:

Qlikview Max Number Straight Table Chart

Once you apply this setting, your updated chart will look like this:

Qlikview Max Number Straight Table Chart

Now, you only see the top 10 players, but you also see a total at the bottom of the chart.  To remove this, set the following property in the “Expressions” tab of the chart property window:

Qlikview Max Number Straight Table Chart

Your chart will now look like this:

Qlikview Max Number Straight Table Chart

An easy solution to display the Top 10 players based on total points!

If you’d like to make this interactive for the user, simply setup an Input Box object, then link associated variable with the “Max Number” property of the Straight Table Chart:

Qlikview Max Number Straight Table Chart

Now, your users can determine how many records to display in the chart!  Here is what it might look like:

Qlikview Max Number Straight Table Chart

Here is the LOAD SCRIPT with sample data used in this post:

 

 

Additional Content

Check out more examples by visiting my Home Page

Here you will find topics covering  Qlikview  SQL Server  Excel VBA

 

 

 

Leave a Comment