# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for
Did you mean:
Contributor II

## How show highest month with more sales

Hi there,

I have a doubt, I'd like show a KPI the highest month in sales:

 Year Month Products Amount 2017 Jan 24 88,800 2017 Jan 28 103,600 2017 Jan 34 125,800 2017 Jan 40 148,000 2017 Feb 24 88,800 2017 Feb 14 51,800 2017 Mar 80 29,600 2017 Mar 50 18,500 2017 Apr 30 11,100 2017 Apr 20 7,400 2017 May 10 3,700 2017 May 80 2,000 2017 May 95 40,000 2017 May 10 74,000 2017 Jun 15 3,700 2017 Jun 20 9,000 2017 Jul 30 12,000 2017 Aug 10 20,000 2017 Sep 40 14,800 2017 Oct 60 22,200 2017 Nov 12 44,400 2017 Dec 18 66,600

I'd like to answer 2 Question at least:

1.- What's the month with more sales (In Products)?

2.- What's the month with more sales (In Amount)?

What I'm looking for is a function to solve and get this one:

Top Products

May 195

Top Sales

Jan 466,200

1 Solution

Accepted Solutions
MVP

In a textbox?

try something like

=Maxstring( Aggr( dual(Month & ' ' & Money(Sum(Amount)), Sum(Amount)), Year., Month))

=Maxstring( Aggr( dual(Month & ' ' & Num(Sum(Products)), Sum(Products)), Year., Month))

2 Replies
MVP

In a textbox?

try something like

=Maxstring( Aggr( dual(Month & ' ' & Money(Sum(Amount)), Sum(Amount)), Year., Month))

=Maxstring( Aggr( dual(Month & ' ' & Num(Sum(Products)), Sum(Products)), Year., Month))

Contributor II
Author

Simply... You're the best, Stefan...

Thank you very much...

Kind Regards

Luis

Community Browser