Set Analysis

[risabhroy_03]

I have 3 fields below Company Code, NumDate, Weight.

Each company code has multiple dates stored.

I want to sum my Weight on the basis of the Maximum Numdate for each company code.

Example - For company code 215, my weight should be on the basis of the maximum NumDate that is 15-12-21.

For Company code 220, my weight should be on the basis of the maximum NumDate that is 17-12-21.

Can anyone help me achieve this?

[anat]

have u tried below link

https://community.qlik.com/t5/New-to-Qlik-Sense/Qlik-Sense-Select-only-a-maximum-date-for-a-given-re...

[risabhroy_03]

Can i use it without if.

I want to do it with only set analysis.