Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Live chat with experts, bring your API Integration questions. June 15th, 10 AM ET. REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
tinkerz1
Creator II
Creator II

Syntax for 2 Inner Joins on 2 Group bys

SourceHi,

I am trying to use the same source table to find the maximum for 2 different groups and pull the distinct ID's for them
.

So the max ID of the order number and the Max Cust ID of the customer number.

So then I will have 1 table of both.

Where am I going wrong?

Source1:

LOAD

ID,

Cust-ID,

order_number,

cust_number

FROM $(File)

inner join (Source1)

LOAD

[ID],

MAX(order_number) as [ODnum]

resident (Source1)

group by

[ID];

inner join (Source1)

LOAD

[cust-ID],

MAX(cust_number) as [Cust_num]

resident (Source1)

group by

[cust-ID];

2 Replies
MK_QSL
MVP
MVP

Try Left Join instead of Inner Join

tinkerz1
Creator II
Creator II
Author

It was just a typo in my join field that threw the exception