Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
I think the one I posted has this feature
yes, its working. thank you