topic Firstsortedvalue application on a table in QlikView

Firstsortedvalue application on a table

canmarroig — Fri, 15 Nov 2024 23:42:52 GMT

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?

Re: Firstsortedvalue application on a table

Kushal_Chawda — Fri, 30 Oct 2020 11:02:12 GMT

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

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

Re: Firstsortedvalue application on a table

canmarroig — Fri, 30 Oct 2020 11:08:03 GMT

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