Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
canmarroig
Partner - Creator
Partner - Creator

Firstsortedvalue application on a table

I need to find the shop where my customer have been the last time, based on the max date of my receipt, i've build this simple function but it doesn't run: 

=firstsortedvalue([Receipt_date],[Shop_name])  then i've tried to find the max receipt_date but in firstsortedvalue there is already the max function i suppose, can you help me? 

Labels (1)
1 Solution

Accepted Solutions
Kushal_Chawda

@canmarroig  just swap the parameter with bit modification. read more about this function in qlik help site

=firstsortedvalue([Shop_name],-[Receipt_date]) 

View solution in original post

2 Replies
Kushal_Chawda

@canmarroig  just swap the parameter with bit modification. read more about this function in qlik help site

=firstsortedvalue([Shop_name],-[Receipt_date]) 

canmarroig
Partner - Creator
Partner - Creator
Author

Thank you i've checked different examples, but i did't understand.