Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Specialist
Specialist

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
Not applicable
Author

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))