# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

## 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?

12 Replies
MVP

## 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?

MVP

## 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)

Not applicable

## 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.

MVP

## 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).

Not applicable

## 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.

MVP

## 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?

Honored Contributor II

Not applicable

## 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.

Not applicable

## 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.