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: 
Vijayqliksept12
Contributor
Contributor

i want show in Text Object maximum product id and minimum product id using shipcost in One Text Object both Id i want to display

Vijayqliksept12_0-1632388326078.png

 

1 Solution

Accepted Solutions
jyothish8807
Master II
Master II

Hi @Vijayqliksept12 ,

Try this:

='Min :'&FirstSortedValue(Productid,Aggr(sum(Shipid),Productid)) & ' Max :'& FirstSortedValue(Productid,-Aggr(sum(Shipid),Productid))

Best Regards,
KC

View solution in original post

3 Replies
jyothish8807
Master II
Master II

Hi @Vijayqliksept12 ,

Try this:

='Min :'&FirstSortedValue(Productid,Aggr(sum(Shipid),Productid)) & ' Max :'& FirstSortedValue(Productid,-Aggr(sum(Shipid),Productid))

Best Regards,
KC
Vijayqliksept12
Contributor
Contributor
Author

is there any chance use only function like =only({<Productid={'$(=max(Productid))','$(=min(Productid))'}>}shipid)

if any above statement wrong correct me

 

jyothish8807
Master II
Master II

You can try this as well:

=only({<Cost={'$(=min(Cost))'}>}Productid)
=only({<Cost={'$(=max(Cost))'}>}Productid)

Best Regards,
KC