Qlik Community

Qlik Scalability

A group dedicated to advancing QlikView's scalability and performance. In this group we will share knowledge on how to perform load tests of Qlikview.

Highlighted
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

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'

3 Replies

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'

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;

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