topic Re: display top3 owners defect counts in QlikView

display top3 owners defect counts

Anonymous — Fri, 29 Aug 2014 06:20:03 GMT

Hi All,

I have defect table and displaying top3 defect owners name list in single text object.

Now I want to display top3 owners defect counts also in the same text object.

below one currently using for displaying owners name list,

Concat(IF(aggr(Rank(Sum(passed)),executedby)<=4,executedby & chr(10)))

IF ANYONE HAVE IDEA TO MODIFY THE ABOVE EXPRESSION,PLS SHARE

THANKS,

Prakash

jagan — Fri, 29 Aug 2014 06:39:54 GMT

Hi,

Try like this

Concat(IF(aggr(Rank(Sum(passed)),executedby)<=4,Sum(passed) & chr(10)))

Concat(IF(aggr(Rank(Sum(passed)),executedby)<=4,executedby & ' ' & Sum(passed) & chr(10)))

Hope this helps you.

Regards,

Jagan.

MK_QSL — Fri, 29 Aug 2014 08:07:15 GMT

=CONCAT(IF(Aggr(Rank(SUM(passed),4),executedby)<=3,executedby &CHR(10)),'',-Aggr(SUM(passed),executedby))