Newbie issues MAX () function

[#1]

Hi

Im very new to click view and was wondering if anyone can help with using the MAX function on the data load editor.

So I dont pull in duplicate records Im trying to run this SQL statement:

however I get a message saying "Invalid expression".

Any help would be greatly appreciated.

thanks

Gareth

[simondachstr · Accepted solution]

I'm missing a Group By clause for the aggregation in qlikview. Make sure there's no space between MAX and the bracket (

[Anonymous]

Hi,

You should not use aggregation fields in groupby.

try without Counte in groupby function.

Nitha

[#4]

Thanks you both for your responses, its now working fine.

Thanks

Gareth