topic Re: Newbie issues MAX () function in App Development

Newbie issues MAX () function

Tue, 30 Sep 2014 11:34:14 GMT

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 — Tue, 30 Sep 2014 11:48:43 GMT

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

Anonymous — Tue, 30 Sep 2014 11:51:21 GMT

Hi,

You should not use aggregation fields in groupby.

try without Counte in groupby function.

Nitha

Tue, 30 Sep 2014 13:50:27 GMT

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

Thanks

Gareth