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: 
Not applicable

Top 10 sales of countries

Hi,

i want top 10 countries data based on sales .

But should not use dimension limits.

should not use Aggregation rank function.

is there any option to solve this

if it is so which will give better performance rank with aggregation or given answer let me know

regards

Mahesh

5 Replies
MK_QSL
MVP
MVP

Create a Straight Chart

Dimension :

Country

Expression

SUM(Sales)

Sort Data for Country by Expression = SUM(Sales)

Descending Order

Now under Dimension Limit

Tick restrict which values.....

Show Only

Largest and 10 values....

rustyfishbones
Master II
Master II

Use RANK with AGGR

There is a video on youtube that shows how to do this

Go to youtube and type Qlikview RANK

Not applicable
Author

I should not use dimension limits or agrregation and rank

alternative 3rd appraoch

nirav_bhimani
Partner - Specialist
Partner - Specialist

Hi

I think you should do that at script level with group by & Order by Desc

& then create a flag for those value.

Use that flag in the expression.

Regards,

Nirav bhimani

jagannalla
Partner - Specialist III
Partner - Specialist III

Hi,

Hope it helps you.

T:

LOAD Country,

    Sales,

    RowNo()

FROM

C:\Users\Acer\Desktop\Book1.xlsx

(ooxml, embedded labels, table is Sheet1);

T1:

LOAD Country,RowNo(),

Sum(Sales) as SalesAmt

Resident T

Group By Country

;

MainTable:

First 10

LOAD Country,SalesAmt Resident T1 Order By SalesAmt desc;

DROP Table T,T1;

Thanks,

Jagan