Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Sacha
Contributor
Contributor
‎2021-03-30 04:22 AM

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)
,[Lead.Id]))

I tried to add : 

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

Can you help me?

Best Regards,

Labels (2)
Labels
772 Views
0 Likes
0 Replies