Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Problem with aggregation

Hey everyone,

im developing a new report about warehouse's. I have this little problem with an aggregation:

I have a Lot Status Field, this field may change in every line of the Lot Events Table.

The Lot Events Table has a transaction_date field with this format (dd/mm/yyyy hh.mm).

What i want to do is to take the lot status of the last transaction in the table lot events.

I tried Aggr(max(Trans_Date), Lot_status) but is returning -.

Ty for your time

Regards

Juan Pedro

1 Solution

Accepted Solutions
Not applicable

Re: Problem with aggregation

U can write script like this

if(TransDate=Aggr(max(Trans_Date), Lot_status),Lot_Status)

if u give sample data, than we can give correct expression..  pls post sample

2 Replies
Not applicable

Re: Problem with aggregation

U can write script like this

if(TransDate=Aggr(max(Trans_Date), Lot_status),Lot_Status)

if u give sample data, than we can give correct expression..  pls post sample

Not applicable

Re: Problem with aggregation

Is working fine now thnks

Community Browser