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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
bbastro1106
Contributor III
Contributor III

Sum if date equal to particular month

Hi All,

I would like to get the SUM of UNITS, if the RECEIPT DATE is equal to 'Jan'.

To get the Month of the date, i know it should be 

Month([RECEIPT DATE])

But it seems below formula is not correct, can anyone please help?

Sum({$<month([Receipt Date])={'Jan'}>} [Units])

1 Solution

Accepted Solutions
Anil_Babu_Samineni

Perhaps these?

Sum(if(month(date)='jan', units))

Or

Sum({<date={"= month(date)='jan'"}>} units)

And I would always think

Sum({<monthfield={'jan'}>} units) where as monthfield is created in script if month field and date field are associated.

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

View solution in original post

1 Reply
Anil_Babu_Samineni

Perhaps these?

Sum(if(month(date)='jan', units))

Or

Sum({<date={"= month(date)='jan'"}>} units)

And I would always think

Sum({<monthfield={'jan'}>} units) where as monthfield is created in script if month field and date field are associated.

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful