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.
Company RANK Financial_Year
A 21 2021
A 22 2022
B 46 2021
B 56 2021
C 78 2021
C 36 2022
Please Help