topic Re: How to get min value in text in QlikView

How to get min value in text

Thu, 26 Jul 2012 19:07:01 GMT

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

Re: How to get min value in text

MayilVahanan — Thu, 26 Jul 2012 19:11:13 GMT

Hi,

Try like this:

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

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

Re: How to get min value in text

Thu, 26 Jul 2012 19:16:24 GMT

I want the customer name who has min amount ie vipin

Re: How to get min value in text

CELAMBARASAN — Thu, 26 Jul 2012 19:22:08 GMT

Try this

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

Re: How to get min value in text

MayilVahanan — Thu, 26 Jul 2012 19:26:28 GMT

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

Hope it helps