Qlik Community

Ask a Question

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 
Search instead for 
Did you mean: 
luisdarwinqlik
Contributor II
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:

  

YearMonthProducts Amount
2017Jan24  88,800
2017Jan28  103,600
2017Jan34    125,800
2017Jan40     148,000
2017Feb24       88,800
2017Feb14       51,800
2017Mar80       29,600
2017Mar50       18,500
2017Apr30       11,100
2017Apr20         7,400
2017May10         3,700
2017May80         2,000
2017May95       40,000
2017May10       74,000
2017Jun15         3,700
2017Jun20         9,000
2017Jul30       12,000
2017Aug10       20,000
2017Sep40       14,800
2017Oct60       22,200
2017Nov12       44,400
2017Dec18       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
swuehl
MVP
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))

View solution in original post

2 Replies
swuehl
MVP
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))

View solution in original post

luisdarwinqlik
Contributor II
Contributor II
Author

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

Thank you very much...

Kind Regards

Luis