Discussion board where members can learn more about Qlik Sense App Development and Usage.
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.
Go to Solution.
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.