Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

mohamed_ahid
Contributor III

getting a specific value on table

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

1 Solution

Accepted Solutions
MVP
MVP

Re: Re: getting a specific value on table

Like attached sample?

4 Replies

Re: getting a specific value on table

Hi,

Have a look at firstsortedvalue() function.

Can you post sample data.

Regards

ASHFAQ

mohamed_ahid
Contributor III

Re: getting a specific value on table

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   

MVP
MVP

Re: Re: getting a specific value on table

Like attached sample?

mohamed_ahid
Contributor III

Re: getting a specific value on table

Thanx everybody it works with tresesco's solution.

Community Browser