This one is going to be a little difficult to explain, but I'll try my best.
For good reasons I have a table with key values where:
One KEY value is simply "TRANS" and points to all of the transactions in my FACT table
The remainder of the KEY values is "FMV" + a Reporting Date (Month End)
I am doing this in order to calculate IRR values that require all the cashflow transactions plus a single FMV value at the end of the last month in the selection. So, once I have selected a month end, I am triggering a selection of TRANS + FMVReportDate in my fact. This works very well to calculate a single IRR value at a single report date.
My problem.....
I have a chart that should show the IRR values with a report date dimension, in a "normal" data model this is easy enough, I simply add the Report Date as a dimension to the chart and QlikView takes care of everything. In my special data model however, I need to somehow tell QlikView to always have TRANS selected whilst iterating over the report date keys as well, so it should be showing me a chart based on the following field selections:
TRANS + FMV31032008
TRANS + FMV30062008
TRANS + FMV30092008
TRANS + FMV31122008
As I said above, I'm not sure this is explaining things very well, but I'm struggling to know how to put it better.
