topic looking for example data per multiple end of month in QlikView https://community.qlik.com/t5/QlikView/looking-for-example-data-per-multiple-end-of-month/m-p/1350566#M415164 <HTML><HEAD></HEAD><BODY><P>For example :</P><P>We have an invoice table with fields: amount, date_received and date_paid</P><P>In a chart I want to visualize the total amount for all invoices that are reived,but not paid per monthend</P><P></P><P>Dimension = monthend</P><P>expression = sum(amount)</P><P></P><P>So when an invoice is received in January and paid in May then I want a total for</P><P>January 31</P><P>February 28</P><P>March 31</P><P>April 30</P><P></P><P>Now I am looking for an example of a script , how to achieve this.</P><P>In real life I I have more dimensions</P></BODY></HTML> Thu, 20 Apr 2017 12:49:05 GMT curiousfellow 2017-04-20T12:49:05Z looking for example data per multiple end of month https://community.qlik.com/t5/QlikView/looking-for-example-data-per-multiple-end-of-month/m-p/1350566#M415164 <HTML><HEAD></HEAD><BODY><P>For example :</P><P>We have an invoice table with fields: amount, date_received and date_paid</P><P>In a chart I want to visualize the total amount for all invoices that are reived,but not paid per monthend</P><P></P><P>Dimension = monthend</P><P>expression = sum(amount)</P><P></P><P>So when an invoice is received in January and paid in May then I want a total for</P><P>January 31</P><P>February 28</P><P>March 31</P><P>April 30</P><P></P><P>Now I am looking for an example of a script , how to achieve this.</P><P>In real life I I have more dimensions</P></BODY></HTML> Thu, 20 Apr 2017 12:49:05 GMT https://community.qlik.com/t5/QlikView/looking-for-example-data-per-multiple-end-of-month/m-p/1350566#M415164 curiousfellow 2017-04-20T12:49:05Z