Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
siva_boggarapu
Creator II
Creator II

How to show 1st three in Minimum values in Straight table?

Hi Everyone,

I have two fileds like below

NameCost
AAA100
BBB200
CCC300
DDD400
EEE500
FFF600

I want to show first 3 minimuvalues in straight table. ie AAA-100,BBB-200, CCC-300

Can anyone suggest me how to do this?

Best,

Siva

1 Reply
Not applicable

Hi,

1. Go to the properties of Straight Table and tick on the Maximum Number check box and put there 3 then

2.sort your expression in Ascending order in Sort tab.

then you will get 3 rows with min values.

Regards

Apurva