Qlik Community

Qlik Sense Cloud Discussions

wesbrowning
New Contributor III

Count based on multiple criteria

After searching and thinking I found the correct recipe I've had to call no joy and ask for assistance.  I'm sure it's quite simple but I humbly ask for help. 

Basically - I want to count the # of days that meet two specific criteria: for a particular person and within the current year.

I tried this based on what I could deduce from other posts, but didn't work.  Hoping someone can asstst.

Count({{<[TAM Manager]={'Wes Poole'}>},{<[Service Delivery Date.autoCalendar.Year]={$(=Year(Today()))}>}}[Service Delivery Date.autoCalendar.YearMonth])


So... Criteria to meet: [TAM Managar] AND [Service Delivery Date.autoCalendar.Year]

Count: [Service Delivery Date.autoCalendar.Year] meeting above criteria.


Thanks in advance for your help!


Wes

Tags (2)
1 Solution

Accepted Solutions

Re: Count based on multiple criteria

Try this

Count({<[TAM Manager] = {'Wes Poole'}, [Service Delivery Date.autoCalendar.Year] = {$(=Year(Today()))}>} [Service Delivery Date.autoCalendar.YearMonth])

2 Replies

Re: Count based on multiple criteria

Try this

Count({<[TAM Manager] = {'Wes Poole'}, [Service Delivery Date.autoCalendar.Year] = {$(=Year(Today()))}>} [Service Delivery Date.autoCalendar.YearMonth])

wesbrowning
New Contributor III

Re: Count based on multiple criteria

Thanks, Sunny!  That worked perfectly.

Community Browser