https://community.qlik.com/t5/App-Development/Current-Year-Rank-Previous-Year-Rank-Dynamically/m-p/2008261#M83403 <P>If anyone knows the solution or is expert in Qlik sense please help me with this . I just want to show (current year rank - Previous year rank) in a dynamic way. That means if new data is loaded its automatically calculates the rank and displays. Please someone help me over this its really urgent.&nbsp;</P> <P>&nbsp;</P> <P>Company&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RANK&nbsp; &nbsp; &nbsp;Financial_Year</P> <P>&nbsp; &nbsp; A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;21&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2021</P> <P>&nbsp; &nbsp; A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 22&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2022</P> <P>&nbsp; &nbsp; B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;46&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2021</P> <P>&nbsp; &nbsp; B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 56&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2021</P> <P>&nbsp; &nbsp; C&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 78&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2021</P> <P>&nbsp; &nbsp; C&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 36&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2022</P> <P>Please Help</P> <P>&nbsp;</P> Wed, 23 Nov 2022 14:03:45 GMT aarav021 2022-11-23T14:03:45Z https://community.qlik.com/t5/App-Development/Current-Year-Rank-Previous-Year-Rank-Dynamically/m-p/2008261#M83403 <P>If anyone knows the solution or is expert in Qlik sense please help me with this . I just want to show (current year rank - Previous year rank) in a dynamic way. That means if new data is loaded its automatically calculates the rank and displays. Please someone help me over this its really urgent.&nbsp;</P> <P>&nbsp;</P> <P>Company&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;RANK&nbsp; &nbsp; &nbsp;Financial_Year</P> <P>&nbsp; &nbsp; A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;21&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2021</P> <P>&nbsp; &nbsp; A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 22&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2022</P> <P>&nbsp; &nbsp; B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;46&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2021</P> <P>&nbsp; &nbsp; B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 56&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2021</P> <P>&nbsp; &nbsp; C&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 78&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2021</P> <P>&nbsp; &nbsp; C&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 36&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2022</P> <P>Please Help</P> <P>&nbsp;</P> Wed, 23 Nov 2022 14:03:45 GMT https://community.qlik.com/t5/App-Development/Current-Year-Rank-Previous-Year-Rank-Dynamically/m-p/2008261#M83403 aarav021 2022-11-23T14:03:45Z