Get Top 1 Value regardless selections applied

[Anonymous]

Hi,

I've attached a qvw sample, and all the files I'm using.

I want to get the value of top 1 Metric Value in a text object.

But I don't want the selections I made, in filter Code, to change this value.

the top 1 Metric Value is 4,50, so regardless selection it should always show 4,50.

Can you please help?

More information is in the qvw sample.

Thanks in advanced,

Sílvia

[sunny_talwar · Accepted solution]

Try this:

=Max({<Code, Active={"1"}>} Aggr(

if(Avg({<Code=,Metric={"Satisfaction"}>}Value / #RecordCount) <= sum(TOTAL {<Outlier_Metric={"SMC"}, Code>} Outlier), Round(Avg({<Code=,Metric={"Satisfaction"}>}Value / #RecordCount),0.01)), Code))

[Anonymous]

Thank you, Sunny