Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Get Top 1 Value regardless selections applied

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

1 Solution

Accepted Solutions
sunny_talwar

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

View solution in original post

2 Replies
sunny_talwar

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
Not applicable
Author

Thank you, Sunny