Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Getting the Min(worst) customer name across several dimensions

I would like to get the name of our worst customer.

I'm able to get the $ amounts now using set Analysis and

Min(Aggr(Sum{$<>}Amount), Region,Territory,CustomerName).

How to use the same type of expression to get the actual customer name?

Thanks

1 Solution

Accepted Solutions
chematos
Valued Contributor II

Re: Getting the Min(worst) customer name across several dimensions

You can try this:

only({1<Amount={'<=min(Amount)'}>} [customer name])

or

FirstSortedValue([customer Name] ,Amount)

or

aggr(FirstSortedValue([customer Name] ,Amount), Region,Territory)


3 Replies
shree909
Valued Contributor II

Re: Getting the Min(worst) customer name across several dimensions

Try like this

Min(Aggr(Sum({$<cusomer={'Worst cutomer'}>}Amount), Region,Territory,CustomerName).

Not applicable

Re: Getting the Min(worst) customer name across several dimensions

This would not work.  Customer='Worst customer' is a filter and it does not exist.

If it did, it would only show me the dollar amount for the 'Worst customer'.

The Min function will only show me a Min dollar amount.

Thanks

chematos
Valued Contributor II

Re: Getting the Min(worst) customer name across several dimensions

You can try this:

only({1<Amount={'<=min(Amount)'}>} [customer name])

or

FirstSortedValue([customer Name] ,Amount)

or

aggr(FirstSortedValue([customer Name] ,Amount), Region,Territory)


Community Browser