https://community.qlik.com/t5/App-Development/Data-modelling/m-p/2438091#M97099 <P>Hi,&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/294381">@sureshmaddipati</a>&nbsp;<BR /><BR /></P> <P>See with the function above:<BR /><BR /><A href="https://help.qlik.com/pt-BR/sense/February2024/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/InterRecordFunctions/above.htm#:~:text=Above()%20avalia%20uma%20express%C3%A3o,ser%C3%A1%20a%20linha%20diretamente%20acima" target="_blank" rel="noopener">https://help.qlik.com/pt-BR/sense/February2024/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/InterRecordFunctions/above.htm#:~:text=Above()%20avalia%20uma%20express%C3%A3o,ser%C3%A1%20a%20linha%20diretamente%20acima</A>.</P> <P>I'll leave an example below, adapt it according to your fields and expression:<BR /><BR /></P> <PRE id="tw-target-text" class="tw-data-text tw-text-large tw-ta" dir="ltr" data-placeholder="Tradução" aria-label="Texto traduzido" data-ved="2ahUKEwja2rXRoqmFAxVvGrkGHWjaCC8Q3ewLegQIBRAU"><SPAN class="Y2IQFc">If(FieldYear= Year(Today(1)),above(sum([Value]),1), sum([Value]))</SPAN></PRE> <P><SPAN class="Y2IQFc"><BR />Regarts, Matheus</SPAN></P> <P>&nbsp;</P> Thu, 04 Apr 2024 19:20:00 GMT MatheusC 2024-04-04T19:20:00Z https://community.qlik.com/t5/App-Development/Data-modelling/m-p/2437813#M97082 <P>Hi&nbsp;</P> <P>&nbsp;</P> <P>How to pull next year values and show in current year column in qliksense i.e</P> <P>For example: 2024 year values need to show in 2023 year column</P> Thu, 04 Apr 2024 10:47:21 GMT https://community.qlik.com/t5/App-Development/Data-modelling/m-p/2437813#M97082 sureshmaddipati 2024-04-04T10:47:21Z https://community.qlik.com/t5/App-Development/Data-modelling/m-p/2438091#M97099 <P>Hi,&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/294381">@sureshmaddipati</a>&nbsp;<BR /><BR /></P> <P>See with the function above:<BR /><BR /><A href="https://help.qlik.com/pt-BR/sense/February2024/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/InterRecordFunctions/above.htm#:~:text=Above()%20avalia%20uma%20express%C3%A3o,ser%C3%A1%20a%20linha%20diretamente%20acima" target="_blank" rel="noopener">https://help.qlik.com/pt-BR/sense/February2024/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/InterRecordFunctions/above.htm#:~:text=Above()%20avalia%20uma%20express%C3%A3o,ser%C3%A1%20a%20linha%20diretamente%20acima</A>.</P> <P>I'll leave an example below, adapt it according to your fields and expression:<BR /><BR /></P> <PRE id="tw-target-text" class="tw-data-text tw-text-large tw-ta" dir="ltr" data-placeholder="Tradução" aria-label="Texto traduzido" data-ved="2ahUKEwja2rXRoqmFAxVvGrkGHWjaCC8Q3ewLegQIBRAU"><SPAN class="Y2IQFc">If(FieldYear= Year(Today(1)),above(sum([Value]),1), sum([Value]))</SPAN></PRE> <P><SPAN class="Y2IQFc"><BR />Regarts, Matheus</SPAN></P> <P>&nbsp;</P> Thu, 04 Apr 2024 19:20:00 GMT https://community.qlik.com/t5/App-Development/Data-modelling/m-p/2438091#M97099 MatheusC 2024-04-04T19:20:00Z