Qlik Community

Qlik Sense App Development

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

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
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
Highlighted
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