Set Analysis on Line Chart

[#1]

I currently have a line chart that I have applied set anaylyis against the dimension of [Project Name].  I do not want this chart affected by the filter for [Work Entry Year] so I used the following logic, but it is not working.  When someone filters against [Work Entry Year] the chart is being filtered.

aggr(only({$<State={"Request"}, [Work Entry Year]>} [Project Name]), [Project Name])

[Anonymous]

You need to put = sign after [Work Entry Year] :

aggr(only({$<State={"Request"}, [Work Entry Year]=>} [Project Name]), [Project Name])

Please try and let me know

Yaniv

[#3]

I tried adding the = symbol but the chart is still filtered when somone applies the [Work Entry Year] filter.

[#4]

any chance the aggr(only()) function is incorrect?  i am not sure what other function to use when just measuring a dimension / expression against text values.

[#5]

As a workaround, until i can figure out the dimension logic i used the alternate state functionality.

I added a new state "alt1" to my document properties and then pointed the chart to this state whereas the rest are using <inherited state>

[Nicole-Smith]

Just adding the equal sign should work.  I don't think you want to go the alternate states route because that adds a lot more complexity that you don't need.

Please post a sample .qvw and we can help you: Preparing examples for Upload - Reduction and Data Scrambling

[#7]

For some reason, the = sign did not work. 

I will send over a sample .QVW file, not sure if I will get to that today though.

Thanks for following up.

[jpapador]

What do you want your final output to look like?

[kiranmanoharrode]

try below expression

=only(aggr(only({$<State={"Request"}, [Work Entry Year]=>} [Project Name]), [Project Name]))

[Anonymous]

Steve,

To make chart independent from the field selection, you have to use this

{< [Work Entry Year]=>}

in chart expression.  In all expressions if you have multiple.  As I understand, you're using it in calculated dimension now.

Regards,

Michael