topic Re: QlikView - Get Dimension where expression in QlikView

QlikView - Get Dimension where expression

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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 — Wed, 03 May 2017 13:47:08 GMT

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 — Wed, 03 May 2017 14:03:11 GMT

Thanks again Sunny

Regards,

Sílvia