https://community.qlik.com/t5/App-Development/Each-Customer-Join-Plan-Month-retrieve-next-three-month-balance/m-p/2125834#M91618 <DIV class="MessageInResponseTo lia-component-message-view-widget-in-response-to lia-component-in-response-to">&nbsp;</DIV> <DIV id="bodyDisplay" class="lia-message-body lia-component-message-view-widget-body lia-component-body-signature-highlight-escalation lia-component-message-view-widget-body-signature-highlight-escalation"> <DIV class="lia-message-body-content"> <P>Hi All,</P> <P><STRONG>I want to&nbsp;retrieve the data as table like below.</STRONG></P> <P>Customer Join Plan Month&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Balance</P> <P>202301&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;202304</P> <P>202302&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;202305</P> <P>202303&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;202306</P> <P>For Dimension :</P> <P><STRONG>Customer Join Plan Month&nbsp; &nbsp;</STRONG><SPAN>&nbsp;</SPAN>&nbsp;</P> <P>For expression:</P> <P>SUM({$&lt;<STRONG>Month</STRONG><SPAN>&nbsp;</SPAN>={'<SPAN>&nbsp;AddMonths(</SPAN>$(vMaxMonthYear)-3)'}&gt;}[Balance])</P> <P><STRONG>However this expression only can retrieve the latest month balance (202309 -3)of each&nbsp;Customer Join Plan Month like below table</STRONG></P> <P>Customer Join Plan Month&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Balance</P> <P>202301&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;202306</P> <P>202302&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;202306</P> <P>202303&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;202306</P> <P>Can anyone could help&nbsp;</P> </DIV> </DIV> Fri, 06 Oct 2023 01:30:18 GMT eddywong71 2023-10-06T01:30:18Z https://community.qlik.com/t5/App-Development/Each-Customer-Join-Plan-Month-retrieve-next-three-month-balance/m-p/2125834#M91618 <DIV class="MessageInResponseTo lia-component-message-view-widget-in-response-to lia-component-in-response-to">&nbsp;</DIV> <DIV id="bodyDisplay" class="lia-message-body lia-component-message-view-widget-body lia-component-body-signature-highlight-escalation lia-component-message-view-widget-body-signature-highlight-escalation"> <DIV class="lia-message-body-content"> <P>Hi All,</P> <P><STRONG>I want to&nbsp;retrieve the data as table like below.</STRONG></P> <P>Customer Join Plan Month&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Balance</P> <P>202301&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;202304</P> <P>202302&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;202305</P> <P>202303&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;202306</P> <P>For Dimension :</P> <P><STRONG>Customer Join Plan Month&nbsp; &nbsp;</STRONG><SPAN>&nbsp;</SPAN>&nbsp;</P> <P>For expression:</P> <P>SUM({$&lt;<STRONG>Month</STRONG><SPAN>&nbsp;</SPAN>={'<SPAN>&nbsp;AddMonths(</SPAN>$(vMaxMonthYear)-3)'}&gt;}[Balance])</P> <P><STRONG>However this expression only can retrieve the latest month balance (202309 -3)of each&nbsp;Customer Join Plan Month like below table</STRONG></P> <P>Customer Join Plan Month&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Balance</P> <P>202301&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;202306</P> <P>202302&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;202306</P> <P>202303&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;202306</P> <P>Can anyone could help&nbsp;</P> </DIV> </DIV> Fri, 06 Oct 2023 01:30:18 GMT https://community.qlik.com/t5/App-Development/Each-Customer-Join-Plan-Month-retrieve-next-three-month-balance/m-p/2125834#M91618 eddywong71 2023-10-06T01:30:18Z