Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
oen
New Contributor II

Max of another dimension of every single value loaded

<simple question>

I am loading data from various tables.

I have 2 tables which are associated through Contact name.

Customer nameContact name
APeter
AMike
AJohn
BPaula
CPaul

Contact nameScore
Peter80
Mike100
John120
Paul10
Paula10

When I select this data I would like to create a Max Score for every Customer name.

Any clue/hints is highly suggested?

Customer nameMax Score
A120
B10
C10

</simple question>

1 Reply
antoniotiman
Honored Contributor III

Re: Max of another dimension of every single value loaded

Hi Omar,

Temp:
LOAD [Customer name],[Contact name]
FROM "https://community.qlik.com/message/1313701"
(html, codepage is 1252, embedded labels, table is @1);
Left Join LOAD [Contact name],Score
FROM "https://community.qlik.com/message/1313701"
(html, codepage is 1252, embedded labels, table is @2);
LOAD [Customer name],Max(Score) as Score
Resident Temp Group By [Customer name];
Drop Table
Temp;

Regards,

Antonio

Community Browser