topic Two problems: Sum per max month and rangesum in QlikView https://community.qlik.com/t5/QlikView/Two-problems-Sum-per-max-month-and-rangesum/m-p/218719#M71801 <HTML><HEAD></HEAD><BODY><P style="margin: 0cm 0cm 0pt;">I have two problems I can't seem to fix.</P><P style="margin: 0cm 0cm 0pt;"></P><P style="margin: 0cm 0cm 0pt;">1: I need to get a sum per a max date but no matter which formula I use I don't get correct result (Pivot: Paid)</P><P style="margin: 0cm 0cm 0pt;"></P><P style="margin: 0cm 0cm 0pt;">2: I need to have a rangesum (above and below) in order to find primo and ultimo balance for a second dimension in a pivot with two dimensions and the rangesum should be for the first dimension (Pivot: Primo balance).</P><P style="margin: 0cm 0cm 0pt;"></P><P style="margin: 0cm 0cm 0pt;">Please see attached where I have illustrated what I want and the formulas I have used.</P><P style="margin: 0cm 0cm 0pt;"></P><P style="margin: 0cm 0cm 0pt;">Any help would be much appreciated.</P></BODY></HTML> Fri, 09 Jul 2010 12:15:09 GMT 2010-07-09T12:15:09Z Two problems: Sum per max month and rangesum https://community.qlik.com/t5/QlikView/Two-problems-Sum-per-max-month-and-rangesum/m-p/218719#M71801 <HTML><HEAD></HEAD><BODY><P style="margin: 0cm 0cm 0pt;">I have two problems I can't seem to fix.</P><P style="margin: 0cm 0cm 0pt;"></P><P style="margin: 0cm 0cm 0pt;">1: I need to get a sum per a max date but no matter which formula I use I don't get correct result (Pivot: Paid)</P><P style="margin: 0cm 0cm 0pt;"></P><P style="margin: 0cm 0cm 0pt;">2: I need to have a rangesum (above and below) in order to find primo and ultimo balance for a second dimension in a pivot with two dimensions and the rangesum should be for the first dimension (Pivot: Primo balance).</P><P style="margin: 0cm 0cm 0pt;"></P><P style="margin: 0cm 0cm 0pt;">Please see attached where I have illustrated what I want and the formulas I have used.</P><P style="margin: 0cm 0cm 0pt;"></P><P style="margin: 0cm 0cm 0pt;">Any help would be much appreciated.</P></BODY></HTML> Fri, 09 Jul 2010 12:15:09 GMT https://community.qlik.com/t5/QlikView/Two-problems-Sum-per-max-month-and-rangesum/m-p/218719#M71801 2010-07-09T12:15:09Z