Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I am having an issue by trying to combine 2 things:
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
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?