Identifying the movement of a dimension from top 100 to top 15 for daily/weekly/monthly comparison

[KavyaM]

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 🙂

[Chanty4u]

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.'