Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

erwinvullers
New 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

Re: Count if with Week numbers and Year

May be this

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

gareth_wilson12
Contributor II

Re: Count if with Week numbers and Year

Try;

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

gareth_wilson12
Contributor II

Re: Count if with Week numbers and Year

Example Attached

erwinvullers
New Contributor

Re: Count if with Week numbers and Year

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...

Re: Count if with Week numbers and Year

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

Please close the thread by marking correct and helpful responses.

Best,

Sunny

Community Browser