Dynamic Filtering on Line Chart

Wed, 08 Jun 2011 17:27:35 GMT

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

Dynamic Line Chart Expression Setting
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

Dynamic Filtering on Line Chart

Anonymous — Thu, 09 Jun 2011 01:09:08 GMT

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?

topic Dynamic Filtering on Line Chart in QlikView

Dynamic Filtering on Line Chart

Dynamic Filtering on Line Chart