If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I have actually the following formula and I would to exclude Lead with the word Silver in [Lead.LastName] and Gold in [Lead.LastName].
Below it's my formula
count(aggr(if(year([Lead.CreatedDate]) = year(today()-1) and month([Lead.CreatedDate]) = month(today()-1) and [Lead.OwnerId] <> '0051t000004EGlIBUI' ,1),[Lead.Id]))
I tried to add :
and [Lead.LastName] <> 'Silver' but the value decrease from 400 to 0.
Can you help me?