Databases Reference
In-Depth Information
As you can see, this one is easier to read than having all individual values listed in
the dimension column.
The dimension values presented just now show the default format for the bin names.
This is fixed within QlikView, but we can create our own custom format with the
Replace
function, as follows:
Replace(Aggr(Class(Count(DISTINCT [From - To State Code]), 100),
[Carrier Name]), '<= x <', ' - ')
This expression will result in the following dimension values:
A solo exercise using the Class function
Now that you've seen how to create nested aggregations with the use of intervals,
take a moment to create a chart to visualize the number of airlines falling into
different load factor ranges with a bin width of 10 percent. Place it into the
Dashboard
tab.
