topic Re: Finding values in one field, which is associated to maximum value of another in Scalability

Finding values in one field, which is associated to maximum value of another

Thu, 28 May 2015 10:37:51 GMT

Below is the Data:

I want number of calls per contact based on minstring of location'.

Output:

rubenmarin — Thu, 28 May 2015 10:45:00 GMT

Hi Ramesh, if you have a table with Contact and Location as dimension, you can ause this expression:

If(Location=MinString(TOTAL <Contact> Location), Calls)

Check 'Supress zero values'

sunny_talwar — Thu, 28 May 2015 10:50:02 GMT

Try this script:

Table:

LOAD Contact,

Location,

Calls

FROM

[https://community.qlik.com/thread/165913]

(html, codepage is 1252, embedded labels, table is @1);

Right Join(Table)

LOAD Contact,

Max(Calls) as Calls

Resident Table

Group By Contact;

Mon, 01 Jun 2015 06:20:30 GMT

Hi Ruben,

Thanks for the response, With Contact and Location as dimension, we can achieve same with below expression:

if( Location=MinString( aggr(MinString(Location), Contact)), sum(Calls))

-Regards

Ramesh