Question on groups

Tue, 14 Jun 2011 17:24:42 GMT

Question on groups

Tue, 14 Jun 2011 17:25:38 GMT

HI,

I have a line chart with a cyclical group that shows Advances by Advance Group and then Advance Type. The Advance Type roll up to the respective Advance Groups (e.g. the user clicks OVERNIGHT and can then drill to see ARCDAILY, OLOC, OSRA, etc.). Advance Type is the lowest level.

The user has now informed me that they want to see additional categorizations. For example, if they click on Rate Type FIXED, they should be able to expand and see AMORTIZE, FIX30360, FIXCALL, etc.

Does anyone have any advice on how to best accomplish this using a cyclical group? I don’t think a drill down group would make sense since the hierarchy isn’t straightforward. Advance Group has a relationship with Advance Type and Rate Type has a relationship with Advance Type but Advance Group and rate Type do not have a relationship.

I was thinking to create 4 separate groups (Advance Groups, Rate Types, Amortization and Collateral) but I’m having trouble getting them to display on my chart. Maybe there’s a limit to how many groups can appear on a chart?

I was also thinking that I should consider loading the data differently to make this work. Currently I am loading this data from a spreadsheet.

Below is an example of the data I’m working with. Thanks in advance for any help.

Advance_Type	Advance_Group	Rate_Type	Amortization	Collateral
AMORTIZE	TERM	FIXED	AMORTIZER	MORTGAGE
ARC	TERM	VARIABLE	BULLET	MORTGAGE
ARCDAILY	OVERNIGHT	VARIABLE	BULLET	BOTH
FFFLOATR	TERM	VARIABLE	BULLET	MORTGAGE
FIX30360	TERM	FIXED	BULLET	MORTGAGE
FIXCALL	CALLABLE	FIXED	BULLET	MORTGAGE
FIXCONV	PUTABLE	FIXED	BULLET	MORTGAGE
FIXLONG	TERM	FIXED	BULLET	MORTGAGE
FIXMED	TERM	FIXED	BULLET	MORTGAGE
FIXSHRT1	TERM	FIXED	BULLET	MORTGAGE
FIXSHRT2	TERM	FIXED	BULLET	MORTGAGE
FIXSHRT3	TERM	FIXED	BULLET	MORTGAGE
FIXSTRIP	TERM	FIXED	BULLET	MORTGAGE
FXACT360	TERM	FIXED	BULLET	MORTGAGE
OLOC	OVERNIGHT	VARIABLE	BULLET	BOTH
OSRA	OVERNIGHT	VARIABLE	BULLET	BOTH
OVRNGHT	OVERNIGHT	VARIABLE	BULLET	BOTH
PDAMORT	TERM	FIXED	AMORTIZER	BOTH
REPO	TERM	FIXED	BULLET	SECURITIES
REPO2	TERM	FIXED	BULLET	SECURITIES
REPOARC	TERM	VARIABLE	BULLET	SECURITIES
REPOCALL	CALLABLE	FIXED	BULLET	SECURITIES
REPOCONV	PUTABLE	FIXED	BULLET	SECURITIES
REPOLONG	TERM	FIXED	BULLET	SECURITIES
REPOSTRP	TERM	FIXED	BULLET	SECURITIES
VARIABLE	OVERNIGHT	VARIABLE	BULLET	BOTH

topic Question on groups in QlikView

Question on groups

Question on groups