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: 
ankit777
Specialist
Specialist

Some of Top 3 for each country

Hi All,

I have sample data as shown below.

I want to create a straight table with country as dimension. I want to show sum sales for each country, but only the top 3 sales.

Country     Sale

A               5

A               2

A               3

A               7

A               1

B               9

B               2

B               3

B               12

B               4

C               15

C               2

C               1

C               7

C               8

Desired Output

A     15

B     25

C     30

How to achieve this?

12 Replies
ankit777
Specialist
Specialist
Author

This is perfect... Thank you.

amit_saini
Master III
Master III

Ankit,

Like this???

Thanks,
AS

buzzy996
Master II
Master II

pfa,