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: 
Not applicable

How to get min value in text

In the following QVW when i select model  as 600 and vertical as Electric i want to show the minimum amount coming in straight table  into text box along with the customer whose amount is minimum.

Please refer the sheet 1 in the QVW

1 Solution

Accepted Solutions
CELAMBARASAN
Partner - Champion
Partner - Champion

Try this

=FirstSortedValue(Customer, Aggr(Sum(Amount),Customer,Model,Vertical))

View solution in original post

4 Replies
MayilVahanan

Hi,

     Try like this:

     =min(aggr(sum(Amount),Customer)) & '  Customer Name: '&if(GetSelectedCount(Vertical)>0, Concat(distinct Customer,','))

     or

     =min(aggr(sum(Amount),Customer)) & '  Customer Name: '&Concat(distinct Customer,',')

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Not applicable
Author

I want the customer name who has min amount ie vipin

CELAMBARASAN
Partner - Champion
Partner - Champion

Try this

=FirstSortedValue(Customer, Aggr(Sum(Amount),Customer,Model,Vertical))

MayilVahanan

Hi

     =min(aggr(sum(Amount),Customer)) & '  Customer Name:'& FirstSortedValue(Customer,Amount)

     Hope it helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.