topic max date based on status in QlikView

max date based on status

Kumar6872 — Tue, 26 Nov 2019 20:39:39 GMT

Hello All,

I have a below table

Product_ID Product_Status ProductTracking_Date
A Dispatched Jan 1 2019
B Dispatched Jan 3 2019
C In Transit Jan 4 2019
A IN Transit Jan 15 2019
A In transit Jan 30 2019
A In Transit Feb 2 2019
A Delivered Feb 14 2019

I want data to be displayed based on product status "In Transit" max date

Product_ID Product_Status ProductTracking_Date
A In Transit Feb 2 2019
C In Transit Jan 4 2019

Thanks in Advance.

Re: max date based on status

Vengatesh — Wed, 27 Nov 2019 06:21:09 GMT

Add Product ID and Status as Dimension.

Add Expression: Max({<Product_Status={'In Transit'}>}ProductTracking_Date)

Re: max date based on status

Brett_Bleess — Mon, 09 Dec 2019 22:40:38 GMT

Did the post above solve your question? If so, be sure to return to the thread and use the Accept as Solution button on that post to give the poster credit for the assistance and let other Community Members know it worked. If you are still working on things, leave an update as to what you still need.

Regards,
Brett