Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
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