Search Recipes > Visualization (25)

Alternate Total Format

  Alternate Total Format
Version 1, Dec 5, 2013 - QlikView

This example demonstrates using a different number format for chart total rows.

Alternate Total Format

Share

Click image to enlarge

Share

Calendar Chart

  Calendar Chart
Version 1, Feb 7, 2014 - QlikView

A “Calendar Chart” that displays events and metrics in the familiar Month/Weekday page format. The chart is just a cleverly formatted pivot table.

Share

Click image to enlarge

Share

Cell Popups In Straight Table

  Cell Popups In Straight Table
Version 1, Apr 19, 2015 - QlikView

This example demonstrates how to create hover text in Straight and Pivot Table cells.

Share

Click image to enlarge

Share

Conditional Show of Details

  Conditional Show of Details
Version 2, Nov 15, 2015 - QlikView

This example demonstrates using the Conditional Show property to show additional Charts and Text Objects after selecting to a single item.

Revision 2 of this recipe demonstrates showing additional charts after clicking in a bar chart.

conditional show of details 1

conditional show of details 3

Share

Click image to enlarge

Share

Control Chart

  Control Chart
Version 1, Dec 8, 2013 - QlikView

Example of a Control (Shewhart ) Chart.

Control Chart

Share

Click image to enlarge

Share

Defer Selections Until Apply

  Defer Selections Until Apply
Version 1, Dec 4, 2015 - QlikView

There may be unusual cases where you want to the user to make multiple selections before calculating charts(s).

This example demonstrates how you can collect proposed selections in an alternate state and defer applying those selections to charts until  the user presses “Apply”.

Share

Click image to enlarge

Share

Emphasizing Chart Lines

  Emphasizing Chart Lines
Version 1, Jan 6, 2014 - QlikView

How to emphasize specific lines in a line chart. We’ll look at changing line widths, fading colors and hiding lines.

Share

Click image to enlarge

Share

Enter Date From To

  Enter Date From To
Version 1, Dec 9, 2013 - QlikView

This example demonstrates using an Input Box to allow the user to specify date ranges for data selection.

The Constraint property is utilized to demonstrate validating user input.

enter date from to

Share

Click image to enlarge

Share

Focus not Filter

  Focus not Filter
Version 1, Feb 3, 2015 - QlikView

This example demonstrates various techniques to emphasize selected data while still keeping all data in view.

More information can be found in the blog post “Focus not Filter” .

Share

Click image to enlarge

Share

Heat Table Chart

  Heat Table Chart
Version 1, Dec 5, 2013 - QlikView

Color shading or gradients can be used to indicate the relative weight of values in text charts. This can be useful to draw attention to more important values in a dense text chart.

Heat Table Chart

Share

Click image to enlarge

Share

How to Choose an Expression

  How to Choose an Expression
Version 1, Dec 19, 2014 - QlikView

This example demonstrates a technique for improving the performance of a large document when a chart needs to choose one of several expressions based on user selected options.

Complete explanation can be found in this post “How to Choose an Expression“.

Share
Share

Outliers

  Outliers
Version 1.1, Dec 13, 2013 - QlikView

Using a chart expression to remove high and low outlying values from each month before calculating the average Sales. If there are only two or less days in the month, the outliers are not removed.

Share

Click image to enlarge

Share

Pivot Table Grids

  Pivot Table Grids
Version 1, Nov 9, 2015 - QlikView

This recipe provides examples of using a Pivot Table to display data in a grid. The second dimension is dragged to the horizontal creating a cross table.

The Pivot Table provides more options than a Grid chart for representation.

 

Share

Click image to enlarge

Share

Scoping Selections

  Scoping Selections
Version 1, Jan 25, 2016 - QlikView

This example shows how the Aggr() function can be used to narrow or widen selections from a Calculated Dimension.

More on this topic can be found in the blog post  “Scoping Selections with Aggr“.

Share
Share

Selected Warning

  Selected Warning
Version 1, Dec 13, 2013 - QlikView

This example conditionally displays a warning message in the chart when specific values are present in the data.

Click to enlarge image
Share

Click image to enlarge

Share

True False Buttons

  True False Buttons
Version 1, Dec 13, 2013 - QlikView

This example demonstrates several alternatives for controlling True/False switches in a qvw.

Share

Click image to enlarge

Share

Tutorial - About Column Visibility

  Tutorial - About Column Visibility
Version 1, Apr 28, 2014 - QlikView

Chart properties provide options to suppress the display or calculation of a column.

In this tutorial we’ll explore the difference between those two options and look at some use cases.

 

Share

Click image to enlarge

Share

Tutorial - Annotating Chart Data Points

  Tutorial - Annotating Chart Data Points
Version 2, Feb 17, 2014 - QlikView

Annotations are comments or labels placed in a chart to provide additional meaning or interpretation of chart data. Text is placed on a data point or connected visually to the point.

This tutorial will demonstrate techniques for annotating data points in Qlikview Charts.

Share
Share

Tutorial - Continuous Axis And Multiple Scales

  Tutorial - Continuous Axis And Multiple Scales
Version 1, Dec 5, 2013 - QlikView

In this tutorial we’ll learn how to use the continuous X-axis for displaying large numbers of data points. We’ll also look at enriching a line chart with additional measures and scales.

tutorial - continuous axis and multiple scales

Share

Click image to enlarge

Share

Using Alerts To Send Numbers Via Email

  Using Alerts To Send Numbers Via Email
Version 1, Jan 8, 2014 - QlikView

The Qlikview document Alert feature can be used to send text emails with KPIs like “daily numbers” after document reload.

This example shows how to configure an alert and craft an alert text message.

Alerts may not be used to email graphical charts or attachments. Only text may be sent.

144

Share

Click image to enlarge

Share

 

Recipes for Qlikview Success