Discussion Board for collaboration related to QlikView App Development.
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?
inner join (Source1)
MAX(order_number) as [ODnum]
MAX(cust_number) as [Cust_num]
Try Left Join instead of Inner Join
It was just a typo in my join field that threw the exception