Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
kusha_2007
Contributor III
Contributor III

Total YTD Sales of top N customers by YTD sales

Hello All ,

 

I have the below expression to calculate the Total YTD Sales for top N Customers   but the expression is is returing 0 when the current month sales is Zero.

 

=Sum(Aggr(If(Rank($(eActualValueYTDRank)) <= $(vHospRank), $(eActualValueYTDRank)),ListHosp_Ranking))

Any insights on the issue is welecome.

 

Thanks

Kusha

2 Replies
Brett_Bleess
Former Employee
Former Employee

The best I have would be to break apart the expression into smaller chunks putting those into Text boxes to try to figure out which piece is causing the issue, one of my counterparts taught me that trick years ago, but I am still not a very good developer unfortunately! 🙂  Hope this may help if you are still working on it.

The only other place I could point is the Online Help for the different functions you are using to check things there.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
qliksus
Specialist II
Specialist II

The reason could be anything  as a start have u checked with the condition  If(Rank($(eActualValueYTDRank)) <= $(vHospRank)  returns ??