topic Re: Top N Clients in QlikView

Top N Clients

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

Hi Community,

I have one table

I have created one variable vTop, and i have taken one input box. (these are my listed values 5,10,15 20)

in my straight table, i have 2 dimensions.

Dimensions: Client and Employee

Expression: Sum(Revenue)

IF i select top 5 values, not working properly. if i take one dimension working fine.

My top 5 should be this table.

Please any one can help me.

Thanks in Advance.

sunny_talwar — Wed, 01 Mar 2017 13:43:00 GMT

May be try like using Rank() function instead of dimension limits

If(Rank(TOTAL Sum(Revenue)) < 6, Sum(Revenue))

paulwalker — Wed, 01 Mar 2017 13:58:40 GMT

Thanks for Response..

I have to write Dimension level, because i have big expression.

I written dimension level, but it's not working

=Aggr(if(Rank(Sum({<Revenue))<=$(vTop), Employee),Employee)

avinashelite — Wed, 01 Mar 2017 14:06:13 GMT

As you add the Dimensions you need to include them in the AGGR(expression,Dim1,Dim2,Dim3....)

sunny_talwar — Wed, 01 Mar 2017 14:07:54 GMT

May be try this

=Aggr(If(Rank(Sum(Revenue)) <= $(vTop), Employee), Employee)

paulwalker — Wed, 01 Mar 2017 15:05:09 GMT

if i am using this expression not showing Expression Total.

Please can you suggestion ?

sunny_talwar — Wed, 01 Mar 2017 15:25:55 GMT

Then do this

Sum(Aggr(If(Rank(TOTAL Sum(Revenue)) < 6, Sum(Revenue)), Employee, Client))