Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ilanbaruch
Specialist
Specialist

last sell date by item-branch (AGGR?)

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

1 Reply
YoussefBelloum
Champion
Champion

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