topic Balance at start date & Balance at date in QlikView https://community.qlik.com/t5/QlikView/Balance-at-start-date-Balance-at-date/m-p/730633#M261726 <HTML><HEAD></HEAD><BODY><P>Hello everyone,</P><P></P><P>I need help and idea how to solve problem that I have.</P><P></P><P>I need to follow cash at start date and cash at end date for current year. For example:</P><UL><LI><STRONG>Cash at start date for January:</STRONG> sum of amount from general ledger entry for all transaction which hapen before 1.1.2014</LI><LI><STRONG>Cash at end date for January:</STRONG> sum of amount from general ledger entry for all transaction which hapen before 1.2.2014</LI><LI><STRONG>Cash at start date for February:</STRONG> sum of amount from general ledger entry for all transaction which hapen before 1.2.2014</LI><LI><STRONG>Cash at end date for February:</STRONG> sum of amount from general ledger entry for all transaction which hapen before 1.3.2014</LI><LI><STRONG>Cash at start date for March:</STRONG> sum of amount from general ledger entry for all transaction which hapen before 1.3.2014</LI><LI><STRONG>Cash at end date for March:</STRONG> sum of amount from general ledger entry for all transaction which hapen before 1.4.2014</LI></UL><P>and like that until current month.</P><P></P><P>When I load transaction in script, how to mark transaction which period they belong, or can I solve problem with set analysis in my pivot chart?</P><P></P><P>Tnx <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 30 Oct 2014 09:32:38 GMT 2014-10-30T09:32:38Z Balance at start date & Balance at date https://community.qlik.com/t5/QlikView/Balance-at-start-date-Balance-at-date/m-p/730633#M261726 <HTML><HEAD></HEAD><BODY><P>Hello everyone,</P><P></P><P>I need help and idea how to solve problem that I have.</P><P></P><P>I need to follow cash at start date and cash at end date for current year. For example:</P><UL><LI><STRONG>Cash at start date for January:</STRONG> sum of amount from general ledger entry for all transaction which hapen before 1.1.2014</LI><LI><STRONG>Cash at end date for January:</STRONG> sum of amount from general ledger entry for all transaction which hapen before 1.2.2014</LI><LI><STRONG>Cash at start date for February:</STRONG> sum of amount from general ledger entry for all transaction which hapen before 1.2.2014</LI><LI><STRONG>Cash at end date for February:</STRONG> sum of amount from general ledger entry for all transaction which hapen before 1.3.2014</LI><LI><STRONG>Cash at start date for March:</STRONG> sum of amount from general ledger entry for all transaction which hapen before 1.3.2014</LI><LI><STRONG>Cash at end date for March:</STRONG> sum of amount from general ledger entry for all transaction which hapen before 1.4.2014</LI></UL><P>and like that until current month.</P><P></P><P>When I load transaction in script, how to mark transaction which period they belong, or can I solve problem with set analysis in my pivot chart?</P><P></P><P>Tnx <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 30 Oct 2014 09:32:38 GMT https://community.qlik.com/t5/QlikView/Balance-at-start-date-Balance-at-date/m-p/730633#M261726 2014-10-30T09:32:38Z