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: 
saradhi_it
Creator II
Creator II

Evaluate top 1 field and value

Hi Friends,

Please help me out in getting top one sales in desired format.

Thanks,
PRS

sd.jpg

2 Replies
maxgro
MVP
MVP

make a chart with 3 expressions

'Product'

FirstSortedValue(Product, -Sales)

max(Sales)

1.png

maximiliano_vel
Partner - Creator III
Partner - Creator III

Products:

LOAD * INLINE [

Product, Sales

a, 10

b, 20

c, 20

d, 50

e, 20

f, 10

g, 10

h, 200

i, 300

j, 100

k, 150

];

NOCONCATENATE

Pro:

LOAD Product,

     Sales

RESIDENT Products

ORDER BY Sales DESC;

LET vMaxProduct = Peek('Product', 0, 'Pro');

LET vMaxSales = Peek('Sales', 0, 'Pro');

DROP Tables Products;