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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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.