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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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