Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Kumar6872
Contributor
Contributor

Data based on max date

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.

 

3 Replies
Lisa_P
Employee
Employee

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

Kumar6872
Contributor
Contributor
Author

Thank you. What does "data" refers to ?

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

Brett_Bleess
Support (Former)
Support (Former)

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.