topic Re: getting top Traderid by orders in QlikView

getting top Traderid by orders

Tue, 21 May 2013 04:18:54 GMT

Hi have Created a table report show Trader wise no of Orders as given below:

i want to get the top traderid who have maximum number of Orders and display that Traderid into Lable or want to use that Traderid in set Analysis.

Please Help.

Thanks in Advance

Sokkorn — Tue, 21 May 2013 04:27:53 GMT

Try this =Only({$<Orders = {$(=Max(Orders))}>} TraderID)

Tue, 21 May 2013 04:31:27 GMT

the Orders field is actually a expression Count(MsgKey) and the MsgKey is combination of Mumber and Character

sushil353 — Tue, 21 May 2013 04:51:08 GMT

Hi,

Try this:

firstsortedvalue(TraderId,-Count(Msgkey))

if you are getting traderid for minimum count then remove the minus "-" sing from Count(Msgkey).

HTH

Sushil

Tue, 21 May 2013 05:02:27 GMT

That is not working, in table box i am getting nothing '-'

sushil353 — Tue, 21 May 2013 05:03:53 GMT

Please share the sample app

Tue, 21 May 2013 05:22:56 GMT

Please find attached file

kumarnatarajan — Tue, 21 May 2013 05:41:11 GMT

Hi,

try this one.

Ex: = Only({$<Traderid={"=Count(MsgKey) = vMaxcount"}>}Traderid)

set below syntex to vMaxcount variable

=max(aggr(Count(MsgKey),Traderid))

find the attached file

Tue, 21 May 2013 05:51:57 GMT

Thanks.. Natarajan.. Its Working Fine...