topic Re: Data based on max date in QlikView

Data based on max date

Kumar6872 — Thu, 21 Nov 2019 22:00:13 GMT

Hello All,

I have following requirement

Product Date

A Jan 1

B Jan 2

A Feb 1

C Feb 2

I want to get the data only for prod A with the latest date

A Feb 1

Thanks in advance.

Re: Data based on max date

Lisa_P — Thu, 21 Nov 2019 22:39:21 GMT

In your chart, use set analysis to aggregate your data:
eg Sum({<Product={A}, Date={$(=max(Date))}>}data)

Re: Data based on max date

Kumar6872 — Fri, 22 Nov 2019 15:17:33 GMT

Thank you. What does "data" refers to ?

Sum({<Product={A}, Date={$(=max(Date))}>}data)

Re: Data based on max date

Brett_Bleess — Thu, 05 Dec 2019 17:07:57 GMT

Kumar, Lisa was referring to the following from your initial post I believe:

"I want to get the data only for prod A with the latest date"

Hopefully this is what you needed, if things do work, be sure you come back and use the Accept as Solution button on her post to give her credit for the help and to let other Community Members know it did work. If you still need further assistance, leave an update.

Regards,
Brett