topic Re: Re: getting a specific value on table in QlikView

getting a specific value on table

mohamed_ahid — Mon, 18 Aug 2014 09:00:17 GMT

hi all ,

i'm trying to get a specific value for a customer in a table .

In my deal table every customer have no deal or several deal .for those having several deals i'm tryin to have the first , second and third deal's date .

how can i do that ?

thx

Re: getting a specific value on table

ashfaq_haseeb — Mon, 18 Aug 2014 09:09:25 GMT

Hi,

Have a look at firstsortedvalue() function.

Can you post sample data.

Regards

ASHFAQ

Re: getting a specific value on table

mohamed_ahid — Mon, 18 Aug 2014 10:05:12 GMT

Thanx Mohammed,

for my order data it schould be like this

ID, OrderDate

1, 12/12/2013

1, 13/12/2013

1, 18/12/2013

1, 28/12/2013

1, 23/12/2013

1, 22/12/2013

2, 06/08/2013

2, 09/08/2013

2, 04/09/2013

3, 01/11/2013

3, 23/11/2013

3, 29/11/2013

3, 17/11/2013

3, 20/11/2013

I want to get for every ID the first , seconde and third order date like this :

ID First Order seconde Order third order

1 12/12/2013 13/12/2013 18/12/2013

2 06/08/2013 09/08/2013 04/09/2013

3 01/11/2013 07/11/2013 20/11/2013

Re: Re: getting a specific value on table

tresB — Mon, 18 Aug 2014 10:12:23 GMT

Like attached sample?

Re: getting a specific value on table

mohamed_ahid — Mon, 18 Aug 2014 12:12:25 GMT

Thanx everybody it works with tresesco's solution.