12 Replies Latest reply: Apr 19, 2016 3:07 AM by Amit Gupta

# how to get highest and lowest 2 percent of the data from some data list

how to get highest and lowest 2 percent of the data from some data list?

• ###### Re: how to get highest and lowest 2 percent of the data from some data list

Amit -

Do you have a sample you can share?

• ###### Re: how to get highest and lowest 2 percent of the data from some data list

You can look into the Fractile() function to find the 2% and 98% percentile:

=Fractile( Data , 0.02)

=Fractile( Data , 0.98)

Then maybe use this as threshold in a list box?

=Aggr(If( Data <= Fractile(TOTAL Data , 0.02),Data), Data)

=Aggr(If( Data >= Fractile(TOTAL Data , 0.98),Data), Data)

• ###### Re: how to get highest and lowest 2 percent of the data from some data list

I am new user for QlikSense Cloud and I am trying to plot a scatter plot between space occupied vs Revenue generated for a store considering only 2% of data with high space occupying & lowest revenue generating products. SO can you guide me that where we need to write fractile function in QlikSense Cloud.

• ###### Re: how to get highest and lowest 2 percent of the data from some data list

Well, as Sunny already said, it's much easier to help with a basic understanding of your setting (data model and data values,  charts with dimension and expression used so far etc).

• ###### Re: how to get highest and lowest 2 percent of the data from some data list

Well I have attached an excel file . So now I want scatter plot for only top 2 percent of "highest space occupying & lowest revenue" points & identify those customer.

• ###### Re: how to get highest and lowest 2 percent of the data from some data list

A customer may not have the same time highest space occupying and lowest revenue.

What should be the logic here?

• ###### Re: how to get highest and lowest 2 percent of the data from some data list

I want intersection of the two i.e. if u refer the attachment then I am looking for co-ordinate A data.

• ###### Re: how to get highest and lowest 2 percent of the data from some data list

Hey the thread shows only to get either top or bottom data corresponding one property like sales but in my case I want to set two property i.e. 2 percent  max area occupied & min revenue directed data.

• ###### Re: how to get highest and lowest 2 percent of the data from some data list

Could you post the desired result, i.e. the list of customers that fulfill your condition?

I am still unclear how you want to combine the two facts into your 2 percent filter.