Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

Newbie issues MAX () function

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:


Qlik Sense Desktop_2014-09-30_12-17-51.png

however I get a message saying "Invalid expression".

Any help would be greatly appreciated.

thanks

Gareth

1 Solution

Accepted Solutions
simondachstr
Valued Contributor III

Re: Newbie issues MAX () function

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

3 Replies
simondachstr
Valued Contributor III

Re: Newbie issues MAX () function

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

Highlighted
neetha_p
Honored Contributor

Re: Newbie issues MAX () function

Hi,

You should not use aggregation fields in groupby.

try without Counte in groupby function.

Nitha

Not applicable

Re: Newbie issues MAX () function

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

Thanks

Gareth