Finding NULLS in set analysis and Concat List

[Anonymous]

Hi All,

I have two tables Tab1 and Tab2. I want to use something like below concat formula in Button (Select in Field) to select all NULL values when there is selection in Year and Month

='('&concat(aggr(if(only({<PCatID = {1}>}CreationDate)< max({<PCatID={2,3,4}>} CreationDate),ItemID), ItemID),'|')&')'

johnw‌ stalwar1‌ hic‌

Thanks in advance,

BR,

SAK

[sunny_talwar]

I don't see creation date in your sample data. Would you be able to provide a sample with the expected output you are looking to get?