https://community.qlik.com/t5/Talend-Studio/Median-in-tAggregateRow/m-p/2244448#M30600 I can't think of a nice one but you could first sort your data then generate a sequence number for each row (use Numeric.sequence("sequencename",1,1)) and temporarily store the flow (using tFileOutput or tHashOutput). Then read back the stored rows to retrieve the value from the count/2 row (either read only that many rows and then use the last function in tAggregateRow or use a tJavaRow to store the value only when the sequence number equals count/2; get the count from the NB_LINE globalMap variable of your output component). Wed, 30 Jun 2010 08:26:04 GMT alevy 2010-06-30T08:26:04Z https://community.qlik.com/t5/Talend-Studio/Median-in-tAggregateRow/m-p/2244445#M30597 Hello! <BR />Is there a way to get the Median in tAggregateRow? <BR />I couldn't find a way <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MPcz.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/157233iD1A564EF62DE3BC2/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MPcz.png" alt="0683p000009MPcz.png" /></span> <BR />thx Sat, 16 Nov 2024 13:22:28 GMT https://community.qlik.com/t5/Talend-Studio/Median-in-tAggregateRow/m-p/2244445#M30597 Anonymous 2024-11-16T13:22:28Z https://community.qlik.com/t5/Talend-Studio/Median-in-tAggregateRow/m-p/2244446#M30598 I suggest you add a new feature request on the BugTracker or add it to <A href="http://www.talendforge.org/bugs/view.php?id=14013" target="_blank" rel="nofollow noopener noreferrer">this one</A>. Wed, 30 Jun 2010 00:32:07 GMT https://community.qlik.com/t5/Talend-Studio/Median-in-tAggregateRow/m-p/2244446#M30598 alevy 2010-06-30T00:32:07Z https://community.qlik.com/t5/Talend-Studio/Median-in-tAggregateRow/m-p/2244447#M30599 Okay. I'll try to get a change. <BR />But I think there must be a way to get the median in a different way.. <BR />Please help - I don't have any ideas <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MPcz.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/157233iD1A564EF62DE3BC2/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MPcz.png" alt="0683p000009MPcz.png" /></span> <BR />Thanks! Wed, 30 Jun 2010 07:57:48 GMT https://community.qlik.com/t5/Talend-Studio/Median-in-tAggregateRow/m-p/2244447#M30599 Anonymous 2010-06-30T07:57:48Z https://community.qlik.com/t5/Talend-Studio/Median-in-tAggregateRow/m-p/2244448#M30600 I can't think of a nice one but you could first sort your data then generate a sequence number for each row (use Numeric.sequence("sequencename",1,1)) and temporarily store the flow (using tFileOutput or tHashOutput). Then read back the stored rows to retrieve the value from the count/2 row (either read only that many rows and then use the last function in tAggregateRow or use a tJavaRow to store the value only when the sequence number equals count/2; get the count from the NB_LINE globalMap variable of your output component). Wed, 30 Jun 2010 08:26:04 GMT https://community.qlik.com/t5/Talend-Studio/Median-in-tAggregateRow/m-p/2244448#M30600 alevy 2010-06-30T08:26:04Z