Top 3 Clients across countries in Qlik Sense Straight Table

[erictanzh]

Hi all,

I'm attempting to plot a straight table visualization to display the top clients based on their values and volumes across countries. My data is accumulative, and my intention is for the data to auto reload from the latest month's worth of data.

I'm currently stuck with this expression - Sum( Aggr(If(Rank(Sum(AUD_AMT), 1) <= 3, Sum(AUD_AMT)),outwardSeller, max(outMonthYear) ,cs.clientCode )

PS - I've attached a simple mock data for ease of referencing

[MayilVahanan]

HI Eric,

Its works fine. Can you say the issue in details if I missed out

[erictanzh]

Hi Mayil,

This does work, but I'm planning to only factor in the current month sales/volumes. How would we add in the MonthYear variable in?

[MayilVahanan · Accepted solution]

hi Eric,

Based on ur sample data, its contains only one date , so do you want to add Max date in ur expression?

If so, try like below

If(Rank(Sum({<pymtDate={"$(=Date(Max(pymtDate),'M/D/YYYY'))"}>}pymtAUD))<=3, Sum({<pymtDate={"$(=Date(Max(pymtDate),'M/D/YYYY'))"}>}pymtAUD))

[erictanzh]

Thanks Mayil,

My actual data will span across 3 years, and I'm looking to sum an entire month's worth of data for this Proof-of-Concept. Your solution is a good guide for me to expand upon this intention.