Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

How to display 1st 5 greater Element in a File

Example

DIm1

Dimention

Qnty

ABC5
DEF10
HIJ15
KLM8
NOP27
QRS30
TUV17
WXY20

Output Should be

DimentionQty
QRS30
NOP27
WXY20
TUV17
HIJ15
1 Solution

Accepted Solutions
Highlighted
Specialist
Specialist

Re: How to display 1st 5 greater Element in a File

If you only want to display the top 5 Dimensions in say a chart or table you can use Dimension Limits in the object properties.

If you only want to load the top five from datasource you will have to handle that differently.

Capture.PNG

View solution in original post

2 Replies
Highlighted
Specialist
Specialist

Re: How to display 1st 5 greater Element in a File

If you only want to display the top 5 Dimensions in say a chart or table you can use Dimension Limits in the object properties.

If you only want to load the top five from datasource you will have to handle that differently.

Capture.PNG

View solution in original post

Highlighted
Not applicable

Re: How to display 1st 5 greater Element in a File

Thank's for Helping,,  is there is any option forTable Box