QlikView - Get Dimension where expression

[Anonymous]

Hi guys,

See the attached sample,

I've calculated the best in class value, my top 1 of Metric Value.

Now I want to get the Code where my Best in class is 4,5 (in the orange box), so I want to get code = 1295.

I want to get this in a text box.

How can I do this?

Thanks in advance,

Sílvia

[sunny_talwar · Accepted solution]

Try this

=FirstSortedValue({<Code, Active={"1"}>} Code, -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]

Thanks again Sunny

Regards,

Sílvia