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.
I'm missing a Group By clause for the aggregation in qlikview. Make sure there's no space between MAX and the bracket (
You should not use aggregation fields in groupby.
try without Counte in groupby function.
Thanks you both for your responses, its now working fine.
Retrieving data ...