Qlik Community

New to Qlik Sense

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

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
erwinvullers
Contributor
Contributor

Count if with Week numbers and Year

Hi there I'm having trouble getting the formula I need.

in an Excel sheet with data, I have a column that is calls 'week number',  one is called 'Year' and I have a column called 'Incident Number'

I want to count all the Incident numbers in the current week and the current year.

First I used this formula Count(IF([Week number]= Week(Today()),[Incident Number])) which works but now I need to add the Year as well.

any one who call help me?

5 Replies
sunny_talwar

May be this

Count({<[Week number] = {"$(=Week(Today())"}, Year = {"$(=Year(Today())"}>} [Incident Number])

gareth_wilson12
Partner
Partner

Try;

=Count(IF([Week number]= Week(Today()) and Year= Year(Today()),[Incident Number]))

gareth_wilson12
Partner
Partner

Example Attached

erwinvullers
Contributor
Contributor
Author

Thanx! that works, I had tried some thing that looks like it but could nog get it to work..Hmm must be my lack of skills...

sunny_talwar

What worked? My response or gareth_wilson124‌'s response?

Please close the thread by marking correct and helpful responses.

Best,

Sunny