topic Re: Last Purcahse Date & Order in QlikView

Last Purcahse Date & Order

Fri, 27 Sep 2013 20:51:35 GMT

Appreciate if someone can kindly help with the attached: sample data set (I have enclosed the expected result)

I am trying to list in the result:

-> All part codes

-> all vendor numbers related to the part (if it is purchased, since a part can be manufactured or purchased)

-> the last purchase date (for the related vendor and part)

-> the last received order (based on the Max value of the order number on the last purchase date)

-> Order line corresponding to the order number

thanks in advance , and I hope I have explained the reuirement without confusion.

Spent considerable time on this and was not able achieve the desired results, had used firstsortedvalue aggr functions, set value etc.

but without success.

Again, thanks in advance, if someone can help me out on this, will be greatly appreciated.

Clever_Anjos — Fri, 27 Sep 2013 21:15:55 GMT

Please check if it fits your needs

Sat, 28 Sep 2013 00:02:31 GMT

Hi Clever:

Greatly appreciate the help, thanks very much. I was not aware of the RowNo() function, wil educate myself.

Thanks once again and have a great weekend.

Clever_Anjos — Sat, 28 Sep 2013 11:48:13 GMT

Please mark this question as answered