Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

bhanu8804
New Contributor

Group by in front end

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?

3 Replies
tomasz_tru
Valued Contributor

Re: Group by in front end

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.

bhanu8804
New Contributor

Re: Group by in front end

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
Honored Contributor

Re: Group by in front end

Create an expression like this:

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