Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Mastering Change Data Capture: Read Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calculate rank based on current month vs previous month

Greetings

Please help to obtain the desired result for calculating ranks.

I would like to rank the products based on the difference of current month and prior month.

(sum({<product= {"=rank(sum(qty), product<=$(vRank)"}, year = 2016  , month = 2 >}  qty)  )

             -

(sum({<product= {"=rank(sum(qty), product<=$(vRank)"}, year = 2016  , month = 1 >}  qty)  )

Thanks!

10 Replies
Not applicable
Author

Many thanks! It's Working.