Using a value in a pivot table as condition

Anonymous — Wed, 15 May 2013 15:27:12 GMT

Hi community,

Is it possible to use a value inside a pivot table as a condition for another column(expression)?

For example, I'm looking at last year's sales and I wanted to see in a column, for a given item, when has was the last sale made (record_date).

So I wrote: max ({$<doc_type = {"SALES"} , doc_status = {"CLOSED"}>} record_date)

And I've found correctly the last record_date.

Since each sale has it's specific document number, I also wanted to find their document number.

The problem is, it's not always in order because the sales aren't always closed in the order they are inserted into the database.

How can I find the doc_nr using the record_date I've found in max ({$<doc_type = {"SALES"} , doc_status = {"CLOSED"}>} record_date)?

Thank you for your help!

topic Using a value in a pivot table as condition in QlikView