Dynamic Filtering on Line Chart

[#1]

Hi, I am having an issue by trying to combine 2 things:

1. Dynamic Line Chart Expression Setting
2. Information filtering

Here is the scenario:

I have a Line chart that currently is evaluating it's only expression dynamically with he following code:

=$(=IntervalExpression)  <-- (Works)

In other pivot charts I am able to show information by using both Aggr funtion and Filtering with the help of set analysis on its only calculated dimension:

Example

=AGGR

(

MAX( {$<HeaderStartDate={">=$(varCalendarStartDateTZ)<=$(varCalendarEndDateTZ)"}>}

    DISTINCT ContactID ),

ContactID

)      <---(Works)

The problem is that I need to filter a Line chart's displayed information and also change its expression dynamically, but when I try to combine both approaches, the expression is not computable

=AGGR

(

MAX( {$<HeaderStartDate={">=$(varCalendarStartDateTZ)<=$(varCalendarEndDateTZ)"}>}

    ContactID ),

$(=IntervalExpression)

)  <--(Doesnt work)

Any Suggestions?

Thanks in advance for you time!

-Ed

[Anonymous]

Hey Ed,

Is it possible for you to attach your .qvw example file? This would make it a bit easier to understand what's going on. What does the IntervalExpression contain for example?