topic Re: purchase date ? in QlikView

purchase date ?

Thu, 13 Nov 2014 06:30:20 GMT

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

Re: purchase date ?

MK_QSL — Thu, 13 Nov 2014 06:35:48 GMT

FirstSortedValue()....this is your function

Re: purchase date ?

sujeetsingh — Thu, 13 Nov 2014 06:37:24 GMT

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.

Re: purchase date ?

sujeetsingh — Thu, 13 Nov 2014 06:37:58 GMT

Follow this thread it is just as per your requirement.

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

Re: purchase date ?

CELAMBARASAN — Thu, 13 Nov 2014 06:41:03 GMT

Use

Aggr(Max(transactiondate), ArticleNo)

expression as dimension

Re: purchase date ?

daveamz — Thu, 13 Nov 2014 06:44:57 GMT

Hi Heather,

See my answer for this post on a similar issue:

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

Regards,

David

Re: purchase date ?

ashfaq_haseeb — Thu, 13 Nov 2014 06:45:12 GMT

Hi,

Check this

Regards

ASHFAQ