Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Rank ?

Hi All,

How to Calculate in Rank in Back end Scripting  for the Getting the TOP 10 Customers...

Kindly help me on this...

Regards,

Helen

14 Replies
sinanozdemir
Specialist III
Specialist III

In the spreadsheet, the maximum order date is 12/29/2009.

Not applicable
Author

Sample data i have shared, u can Fix the Last 12 Months Data & Bring the Top 10 Customers

Regards,

Helen

sinanozdemir
Specialist III
Specialist III

Ok. I don't think you need to handle this in the back-end at all.

I did everything in the front-end:

Capture.PNG

Total Sales within last 12 Months:

Capture.PNG

And Ranking in another column:

Capture.PNG

This is how I would do it, maybe someone else has a different approach. You can also combine the ranking part within a set analysis to only return top 10 customers.

Hope this helps

Kushal_Chawda

HI hbetty2012

Is there any specific reason to do it from back end?

Not applicable
Author

Yes..

Because I need to bring it from Top 15 Stockists based on Last 12 Months Sales..

For Example: Current Month is --Oct-2015

                         Top 15 Stockists --Oct-2014 to Sep-2015


Bifurcation i need to Show as MTD Sales..If any of the 15 Stockists not having the Sales Value in all the MTD Months wise bifurcation that particular stockist is Missing because that particular stockist not having Sales, but Still i need to Show that particular Stockist with Sales Value as 0 in the MTD wise bifurcation..

Regards,

Helen