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