Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

add values of a column for the start of each month

Hi, how should the script be like if I want to add up the balance(refer below) for 1 Jan 14 and 1 Feb 14, 1 Feb 14 and 1 Mar 14, etc,...?

itemnumbalancemonth
231 Jan-14
2101 Feb-14
261 Mar-14
241 Apr-14
281 May-14

Thanks.

11 Replies
Not applicable
Author

sorry i can't open the file. I'm using personal edition. how about screenshot? thanks.

tresesco
MVP
MVP

Expression you got, then be careful of the sort order:

Screen Shot 06-23-14 at 01.13 PM.PNG.png

Update: First expression =balance

               Sec expr= as above