Expression - count only where min(Period)

[QFanatic]

 hi all

Please find attached (Scrambled) model.

so I have one selected Cookie (just to test). In my expression I only want the cookie to appear ONCE where Min (Period) is true.

How can I achieve this? Im not sure how to incorporate this in the existing Aggr setup.

Thanks

[Brett_Bleess]

Going to drop the following Design Blog link for you, and this will also kick things back up to the top, so someone else may have a look and leave something more detailed for you too:

https://community.qlik.com/t5/Qlik-Design-Blog/Pitfalls-of-the-Aggr-function/ba-p/1463275

Here is the base URL for the Design Blog area in case you want to search further on your own for other posts that may help there:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett