Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Steps:
I am trying to get first 80% count,so that i need all the value to be in sorted order.
Please find the attachment
I thought about something like that,,, You can group it as you need, but the calculation isn't dynamic
TABLE:
LOAD
RowNo() as ##,
Name,
Count
FROM [80-20.xls] (biff, embedded labels, table is Sheet1$);
TEMP:
LOAD sum(Count) as TOTAL_COUNT
Resident TABLE;
LET EIGHTY_PERCENT = Peek('TOTAL_COUNT');
DROP Table TEMP;
LOAD
##,
Name,
Count,
if(Rangesum(Count,Peek('Count_Total')) <= 0.8 * $(EIGHTY_PERCENT),'X') as TOP_80_PERCENT,
RangeSum(Count,Peek('Count_Total')) as Count_Total
Resident TABLE;
DROP Table TABLE;
HI,
If You can use Macro (Desktop or IE Plugin)
then this is one way.
See Attachment.
Regards,
Antonio
i can't see the attachment
Attachment
its not there
I don't understand
I think You can use Doc in QVServer in Ajax mode also (without IE Plugin) because APIs called are QV Native.