How to display first and last value ?

[#1]

I am new to qlikeview,  basically i want display first and last (based on user chosen date range )  record from the following rows.

Source

Client	Product	Date	Opening Balance	Addition	Withdrawal	Closing Balance
A	X	01/04/2016	100000	2000	0	102000
A	X	02/04/2016	102000	0	1000	101000
A	X	05/05/2016	101000	0	0	101000
A	X	12/08/2016	101000	3000	0	104000
A	Y	01/04/2016	2000	0	0	2000
A	Y	05/05/2016	2000	100	0	2100
A	Y	12/08/2016	2100	0	50	2050
B	X	01/04/2016	3000	200	0	3200
B	X	12/08/2016	3200	0	50	3150

filter : From 01/04/2016 to 12/08/2016

Output

Client	Product	Date	Opening Balance	Addition	Withdrawal	Closing Balance
A	X	01/04/2016	100000	5000	1000	104000
A	Y	01/04/2016	2000	100	50	2050
B	X	01/04/2016	3000	200	50	3150

[Digvijay_Singh · Accepted solution]

I think the one I posted has this feature

[#3]

yes, its working. thank you