Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am trying to identify the Categories that are moved from Top 100(yesterday) to top 15 today based on the volume in Qlik sense. I am trying to get this by click of a button. I am trying to use RANK function but unable to get the desired result..
Any assistance on this is much appreciated.
Thank you in advance 🙂
Not sure but you can give a try
=Concat({<Date={"Yesterday"}, Rank={"<=100"}>} Category, ', ')
& ' moved from top 100 yesterday to '
& Concat({<Date={"Today"}, Rank={"<=15"}>} Category, ', ')
& ' in top
15 today.'