https://community.qlik.com/t5/App-Development/Year-gap-of-max-sum/m-p/2112672#M90871 <P>Hi Everyone,</P> <P>I have been stuck and couldn’t find the best expression to measure rebooking trend (Year2-Year1+1) for the max sum amount.</P> <P>Referring to table below, I want to measure year gap of the max sum booking.</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="supiah_0-1693798228451.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/115621iEEF5F1FA5F95F1FE/image-size/medium?v=v2&amp;px=400" role="button" title="supiah_0-1693798228451.png" alt="supiah_0-1693798228451.png" /></span></P> <P>The result should be like below:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="supiah_1-1693798252655.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/115622i57E99418D93E1872/image-size/medium?v=v2&amp;px=400" role="button" title="supiah_1-1693798252655.png" alt="supiah_1-1693798252655.png" /></span></P> <P>It would be great if someone can help with this issue.</P> <P>Thank you.</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> Mon, 04 Sep 2023 03:35:16 GMT supiah 2023-09-04T03:35:16Z https://community.qlik.com/t5/App-Development/Year-gap-of-max-sum/m-p/2112672#M90871 <P>Hi Everyone,</P> <P>I have been stuck and couldn’t find the best expression to measure rebooking trend (Year2-Year1+1) for the max sum amount.</P> <P>Referring to table below, I want to measure year gap of the max sum booking.</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="supiah_0-1693798228451.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/115621iEEF5F1FA5F95F1FE/image-size/medium?v=v2&amp;px=400" role="button" title="supiah_0-1693798228451.png" alt="supiah_0-1693798228451.png" /></span></P> <P>The result should be like below:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="supiah_1-1693798252655.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/115622i57E99418D93E1872/image-size/medium?v=v2&amp;px=400" role="button" title="supiah_1-1693798252655.png" alt="supiah_1-1693798252655.png" /></span></P> <P>It would be great if someone can help with this issue.</P> <P>Thank you.</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> Mon, 04 Sep 2023 03:35:16 GMT https://community.qlik.com/t5/App-Development/Year-gap-of-max-sum/m-p/2112672#M90871 supiah 2023-09-04T03:35:16Z