last sell date by item-branch (AGGR?)

[ilanbaruch]

Hi All,

in my model i have sales (invoice lines) by date,branch and item_id

i want to retrive last sell date / max sell date for every item by branch.  i will need only the positive invoice lines.

any ideas ?

advanced thanks

[YoussefBelloum]

Hi,

maybe FirstSortedValue() can help you here

https://help.qlik.com/en-US/sense/September2017/Subsystems/Hub/Content/ChartFunctions/BasicAggregati...

create the table you need and use the function above