topic Re: Getting first order Date in QlikView

Getting first order Date

ashwath26 — Wed, 25 Nov 2020 16:16:04 GMT

Pls help me with the expression to get first order date. I have gone through other similar threads but couldnt understand.

I want the First Order Date of Every Customer.

YoussefBelloum — Wed, 20 Jun 2018 11:45:01 GMT

Hi,

you didn't give any details... nobody will help you like this.

decribe your problem, attach images, sample data, sample app

sasikanth — Wed, 20 Jun 2018 11:50:59 GMT

HI,

Use FirstSortedValue function to get first order date for every customer

you can also get this from script level

Select min(OrderDate), Customer

from Table

Group by Cusomer;

Please do post more details in case if you cannot resolve your issue with the above suggestions.