topic Re: Get Top 1 Value regardless selections applied in QlikView

Get Top 1 Value regardless selections applied

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

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

Re: Get Top 1 Value regardless selections applied

sunny_talwar — Fri, 07 Apr 2017 11:10:30 GMT

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))

Re: Get Top 1 Value regardless selections applied

Anonymous — Fri, 07 Apr 2017 14:56:02 GMT

Thank you, Sunny