topic Re: Top 3 Clients across countries in Qlik Sense Straight Table in App Development

Top 3 Clients across countries in Qlik Sense Straight Table

erictanzh — Thu, 27 Jan 2022 10:04:41 GMT

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

Re: Top 3 Clients across countries in Qlik Sense Straight Table

MayilVahanan — Thu, 27 Jan 2022 10:31:26 GMT

HI Eric,

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

Re: Top 3 Clients across countries in Qlik Sense Straight Table

erictanzh — Fri, 28 Jan 2022 07:00:29 GMT

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?

Re: Top 3 Clients across countries in Qlik Sense Straight Table

MayilVahanan — Fri, 28 Jan 2022 07:38:04 GMT

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))

Re: Top 3 Clients across countries in Qlik Sense Straight Table

erictanzh — Fri, 28 Jan 2022 08:18:43 GMT

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.