Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
silambarasan
Creator II
Creator II

How to achieve aggr with sort in Qlikview 11.20?

Steps:

I am trying to get first 80% count,so that i need all the value to be in sorted order.

17 Replies
silambarasan
Creator II
Creator II
Author

Please find the attachment

Anonymous
Not applicable

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;

antoniotiman
Master III
Master III

HI,

If You can use Macro (Desktop or IE Plugin)

then this is one way.

See Attachment.

Regards,

Antonio

silambarasan
Creator II
Creator II
Author

i can't see the attachment

antoniotiman
Master III
Master III

Attachment

silambarasan
Creator II
Creator II
Author

its not there

antoniotiman
Master III
Master III

I don't understand

antoniotiman
Master III
Master III

I think You can use Doc in QVServer in Ajax mode also (without IE Plugin) because APIs called are QV Native.