Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

support_orbitcs
New Contributor

To find a weekday with maximum customer

I am new to Qlik Sense, with the table like below:

Transaction_Date    Weekday    Customer

2018/04/01               Sun           1

2018/04/02               Mon         2

2018/04/03               Tue           3

2018/04/04               Wed         4

2018/04/05               Thu           5

2018/04/06               Fri             6

2018/04/07               Sat            7

2018/04/08               Sun           8

2018/04/09               Mon         9

2018/04/10               Tue           10

2018/04/11               Wed         11

2018/04/12               Thu          12

2018/04/13               Fri            13

2018/04/14               Sat            14

And I want to return the weekday with the maximum total customer, which is "Sun"

How can I do that?

Thanks to all

1 Reply
MVP
MVP

Re: To find a weekday with maximum customer

May be like this

FirstSortedValue(Weekday, -Aggr(Count(DISTINCT Customer), Weekday))

Community Browser