Calculated Dimension using Input Fields for Trellis Chart

Wed, 22 Oct 2014 20:58:35 GMT

I would like to provide my users an ability to dynamically interact with a large data set to create a customer trellis chart. The goal is to demonstrate changes over a user defined series of periods (weeks, months, quarters, etc).

Example: For a Combination Line and Bar Chart that shows Shipments (Line) and Returns (Bar) , a user would come in and enter into a series of Input Boxes

Pedigree 0 - 'Baseline'

Start Date

End Date

Pedigree 1 = Change 1

Start Date

End Date

Pedigree n = Change = n

Start Date

End Date

Then the chart would pick up 'Pedigree' as a Dimension and display a trellis of the date from Pedigree Start Date 0 to Pedigree n End Date.

The use would be able to create something like the example below.

topic Calculated Dimension using Input Fields for Trellis Chart in QlikView

Calculated Dimension using Input Fields for Trellis Chart