https://community.qlik.com/t5/QlikView/Creating-amortization-plan-in-a-chart/m-p/1529845#M438686 <P>Hi</P><P>I have &nbsp; table With multiple loans, and each of them has a value called [End Balance USD].</P><P>I am trying to put these data in a chart With a Dimension Drilldown that goes from Year-YearQuarter-YearMonth-YearWeek-Date.</P><P>I do not know how to Write the correct set analysis to get the correct loan Balance in these periods, I end up getting the sum of all periods if I Select any lower granularity than Date.</P><P>Anyone that know how to Write an Expression that will pick the value from either the first date or last date in period?</P><P>&nbsp;</P><P>Br Espen</P> Sat, 16 Nov 2024 21:36:34 GMT lordoftrades 2024-11-16T21:36:34Z https://community.qlik.com/t5/QlikView/Creating-amortization-plan-in-a-chart/m-p/1529845#M438686 <P>Hi</P><P>I have &nbsp; table With multiple loans, and each of them has a value called [End Balance USD].</P><P>I am trying to put these data in a chart With a Dimension Drilldown that goes from Year-YearQuarter-YearMonth-YearWeek-Date.</P><P>I do not know how to Write the correct set analysis to get the correct loan Balance in these periods, I end up getting the sum of all periods if I Select any lower granularity than Date.</P><P>Anyone that know how to Write an Expression that will pick the value from either the first date or last date in period?</P><P>&nbsp;</P><P>Br Espen</P> Sat, 16 Nov 2024 21:36:34 GMT https://community.qlik.com/t5/QlikView/Creating-amortization-plan-in-a-chart/m-p/1529845#M438686 lordoftrades 2024-11-16T21:36:34Z