Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Qlik Cloud Maintenance is scheduled between March 27-30. Visit Qlik Cloud Status page for more details.
Showing results for 
Search instead for 
Did you mean: 

Formula does not contain

Dear Comunity, 

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)

I tried to add : 

and [Lead.LastName] <> 'Silver' but the value decrease from 400 to 0. 

Can you help me?

Best Regards,

Labels (2)
0 Replies