purchase date ?

[#1]

Hi All,

I have purchased 1 article many times but i need to display the last time [transactiondate] as my max date of that article in a pivot table..

If I am adding date as dimension it showing all dates,([transactiondate]) for that article..., if i am taking as max of date in text object it is showing fine...

I am adding Max([transactiondate]) then it is showing  // Error in calculated dimension...

date is of format: MM/DD/YYYY

Regards,

Heather

[MK_QSL]

FirstSortedValue()....this is your function

[sujeetsingh]

Firstsorted works as

Imagine you have the following table:

FieldA, FieldB

A, 3

B, 4

C, 1

D, 2

If you run a FirstSortedValue(FieldA, FieldB) you'll get the first sorted value from FieldA based on the sorting of FieldB. Value 1 is the first value for FieldB so the function will in this example return C.

[sujeetsingh]

Follow this thread it is just as per your requirement.

FirstSortedValue. Group By. Any way to do all this in one expression?

[CELAMBARASAN · Accepted solution]

Use

Aggr(Max(transactiondate), ArticleNo)

expression as dimension

[daveamz]

Hi Heather,

See my answer for this post on a similar issue:

http://community.qlik.com/message/655214#655214

Regards,

David

[ashfaq_haseeb]

Hi,

Check this

Regards

ASHFAQ