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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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 (2)
1 Solution

Accepted Solutions
Kushal_Chawda
MVP
MVP

@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
MVP
MVP

@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.