Double selection on a chart dimension???

Fri, 09 Jul 2010 08:35:09 GMT

Hi Folks

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.

topic Double selection on a chart dimension??? in QlikView

Double selection on a chart dimension???