Discussion board where members can get started with QlikView.
i got a problem with this:
I have a table in Qlik
And i want to calculate two new columns with the min and max date of the Order.
I'm using an aggregate expression but when i select in a Selection pannel one date, it not works.
The result i need is:
When I select 05/06/2015 in a Selection pannel, the min of Order 1 must be 01/01/2014, and max of Order 1 must be 05/06/2015.
And to Order 2, the min must be 05/06/2017 and the maximum must be 05/06/2017.
Thanks in advance, any solution is welcome!
perhaps something like this
Load * inline [
1 , 01/01/2014
2 , 06/07/2017
left join load Order, min(date(Date)) as mindate, max(date(Date)) as maxdate resident table Group by Order;
View solution in original post
or in front-end
Thank you Staffan for your response,
it works correctly!