Qliksense Question If then and Date return

[Anonymous]

I have a table containing a  Product Code , a Transaction Type and Date associated with the Transaction Type. There could be multiple Instances of the Transaction Type by date.

Example:-   

Product Code	Date	Transaction Type
0001	01/10/2017	ADJ
0001	29/09/2017	ADJ
0001	27/09/2017	RECP
0001	15/09/2017	RECP

I want to  return the latest RECP Date i.e. 27/09/2017 but, if there is no RECP then return the latest ADJ. 01/10/2017

How can I achieve this in a IF THEN statement

[Anil_Babu_Samineni]

Perhaps this?

Only({<Date = {'$(=Min(Date))'}, [[Transaction Type] -= {'RECP'}>} Date)

[Anonymous]

Hi Anil, Thank  you for your speedy response.

This does not appear to cope with multiple RECP's and it does not provide the last ADJ date if no Receipts found.

[Anil_Babu_Samineni]

On what bases, We are going to have for RECCP's??

[Anonymous]

HI Anil,

Appears to return null values if there is more than one of them ...