Discussion board where members can get started with Qlik Sense.
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?
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.
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.
Create an expression like this: