Group by in front end

[Anonymous]

Hi ,

In my script,it has been written

Select code,name,max(date_t),max(date_u),offername,oferno from xyz table where sdate between (,certain period used in calendar and it restricts data for max field in report,when I select in calendar)

Group by code,name,offername,oferno.

So,how can I implement this in qliksense.Can anyone pls help?

[tomasz_tru]

Just remove aggregations (max) and group by clause. But it is necessary to do it it's better to do aggregations on a database level if you don't need details.

[Anonymous]

If I do that,My data is changed.if I remove,then I have to group by this in the front end.And because of that only I want solution.

[balabhaskarqlik]

Create an expression like this:

Max(Aggr(Sum({$<Productgroup={'ABC'},year={2014,2015}>}Sales),order))