Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
@canmarroig just swap the parameter with bit modification. read more about this function in qlik help site
=firstsortedvalue([Shop_name],-[Receipt_date])
@canmarroig just swap the parameter with bit modification. read more about this function in qlik help site
=firstsortedvalue([Shop_name],-[Receipt_date])
Thank you i've checked different examples, but i did't understand.