Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

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

Tags (3)
1 Reply
Highlighted
Champion
Champion

Re: last sell date by item-branch (AGGR?)

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