Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
geogou1973
Creator
Creator

Aggr Expression

Hello,

I have the following table.

ITEM SUPPLIER DATE PRICE
101642 47922 22/01/2020 5,4
101642 59368 02/07/2020 5,61
101642 59368 27/10/2020 5,61
101642 59368 05/11/2020 5,61
101642 59368 18/11/2020 5,61
101642 59368 28/11/2020 5,61
101642 59368 22/01/2021 5,61
101642 59368 23/01/2021 5,61
101642 46739 16/06/2021 5,05
101642 46739 17/06/2021 5,05
101642 59368 18/06/2021 5,26
101642 59368 22/10/2021 5,26
101642 59368 23/10/2021 5,26

 

With which way i can have the following table. I try with the aggr expression but i haven't the correct results. 

ITEM SUPPLIER MIN DATE MIN PRICE MAX DATE MAX PRICE
101642 46739 16/06/2021 5,05 17/06/2021 5,05
101642 47922 22/01/2020 5,4 22/01/2020 5,4
101642 59368 02/07/2020 5,61 23/10/2021 5,26

 

Can anyone help me ?

Thank you in advanced.

 

0 Replies