Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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

Re: How to get min value in text

Try this

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

4 Replies

Re: How to get min value in text

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,',')

Not applicable

Re: How to get min value in text

I want the customer name who has min amount ie vipin

Re: How to get min value in text

Try this

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

Re: How to get min value in text

Hi

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

     Hope it helps

Community Browser