topic Re: Ignore Selections in Expressions in QlikView

Ignore Selections in Expressions

Fri, 25 Sep 2015 11:05:31 GMT

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

Re: Ignore Selections in Expressions

stigchel — Fri, 25 Sep 2015 11:10:12 GMT

Try with

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

Re: Ignore Selections in Expressions

simenkg — Fri, 25 Sep 2015 11:10:31 GMT

How about:

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

Re: Ignore Selections in Expressions

miguelbraga — Fri, 25 Sep 2015 11:11:27 GMT

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

Re: Ignore Selections in Expressions

Fri, 25 Sep 2015 11:25:16 GMT

Thanks for all the replies.

I have tried them all and still no luck unfortunately

Re: Ignore Selections in Expressions

stephenedberkg — Fri, 25 Sep 2015 11:30:59 GMT

use alternative state

Re: Ignore Selections in Expressions

sasiparupudi1 — Fri, 25 Sep 2015 11:38:27 GMT

How about

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

Re: Ignore Selections in Expressions

MK_QSL — Fri, 25 Sep 2015 11:56:44 GMT

Try

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

Re: Ignore Selections in Expressions

kuczynska — Fri, 25 Sep 2015 11:59:36 GMT

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.

Re: Ignore Selections in Expressions

Fri, 25 Sep 2015 11:59:56 GMT

Thanks Manish and to everyone else who replied