Qlik Community

Qlik Scalability

A group dedicated to advancing Qlik scalability and performance. In this group we will share knowledge on how to perform load tests of Qlik products.

Not applicable

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

Below is the Data:

 

ContactLocationCalls
ConA2
ConB1
Con1A1
Con1B1
Con2B2

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

Output:

 

ContactLocationCalls
ConA2
Con1A1
Con2B2
1 Solution

Accepted Solutions
Highlighted

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

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'

View solution in original post

3 Replies
Highlighted

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

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'

View solution in original post

Highlighted

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

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;

Highlighted
Not applicable

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

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