Ignore Selections in Expressions

[#1]

Hi all,

I have an expression written below that works as expected to show my top Sales man

I would like it to ignore selections from the Salesman field so that the top salesman is always the same. I have tried adding different things to my expression to ignore selections on the Salesman field, but it doesn't work as expected.

Any ideas please.

concat(aggr(if(rank(Sum(Actual)/Sum(Budget)) =1, Salesman),Salesman))

Thanks

[stigchel]

Try with

concat({<Salesman>} aggr(if(rank(Sum({<Salesman>} Actual)/Sum({<Salesman>} Budget)) =1, Salesman),Salesman))

[simenkg]

How about:

concat({<Salesman=>} aggr(if(rank(Sum({<Salesman=>} Actual)/Sum({<Salesman=>} Budget)) =1, Salesman),Salesman))

[miguelbraga]

Hi Razor,

Have you tried to put set analysis indicator before Salesman? If not, make your expression like this:

concat(aggr(if(rank(Sum(Actual)/Sum(Budget)) =1, {1} Salesman), {1} Salesman))

[#5]

Thanks for all the replies.

I have tried them all and still no luck unfortunately

[stephenedberkg]

use alternative state

[sasiparupudi1]

How about

concat({1<Salesman=>} aggr(if(rank(Sum({1<Salesman=>} Actual)/Sum({1<Salesman=>} Budget)) =1, Salesman),Salesman))

[MK_QSL · Accepted solution]

Try

=Concat(DISTINCT {1<Salesman= {"=Rank(SUM({<Salesman>}Actual)/SUM({<Salesman>}Budget))=1"}>}Salesman,',')

[kuczynska]

I was trying to solve very similar issue not long time ago and found the below solution (thanks to Qlik Community!).

My goal was to present the name of the top customer and the associated amount in the text object:

FirstSortedValue(CUSTOMER_NAME,( -aggr( sum(AMOUNT), CUSTOMER_NAME))) 
& ':   ' &
Max( aggr(sum(AMOUNT), CUSTOMER_NAME))

Maybe this will help. You can of course add all qualifier {1} into your SUM() functions to present this as a static value.

[#10]

Thanks Manish and to everyone else who replied