Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I'm missing a Group By clause for the aggregation in qlikview. Make sure there's no space between MAX and the bracket (
I'm missing a Group By clause for the aggregation in qlikview. Make sure there's no space between MAX and the bracket (
Hi,
You should not use aggregation fields in groupby.
try without Counte in groupby function.
Nitha
Thanks you both for your responses, its now working fine.
Thanks
Gareth